#### Charles Williams-SC

##### New member

- Local time
- Yesterday, 20:47

- Joined
- Jul 13, 2020

- Messages
- 6

I have a problem with a formula that I know the Excel experts here can help me with.

In the attached spreadsheet I want to add H13 & J13 together and put it in K13. I tried to combine the formulas in C15:C18 into one formula but I get a #Value error.

I broke down the different parts of the formula in H14:K14 to make sure every part of the formula is working correctly.

The weird thing is, when I reference the cells H14:K14 (See L14) everything works fine.

I know it's probably just a missing closing bracket or something but s very frustrating. Any help from the experts here would be greatly appreciated.

BTW: I am using Excel 2019

In the attached spreadsheet I want to add H13 & J13 together and put it in K13. I tried to combine the formulas in C15:C18 into one formula but I get a #Value error.

I broke down the different parts of the formula in H14:K14 to make sure every part of the formula is working correctly.

The weird thing is, when I reference the cells H14:K14 (See L14) everything works fine.

I know it's probably just a missing closing bracket or something but s very frustrating. Any help from the experts here would be greatly appreciated.

BTW: I am using Excel 2019