Forum Discussion
I'm a New User having issues with a simple Sum
Hi BrandonS1973
You usually get a #VALUE! error when you try to perform a calculation on non-numbers, like below:
Difficult to say more at this time. Could you post a picture showing what you have in your [Item A] & [Item B] columns and the formula you use to SUM these items?
- BrandonS1973Dec 30, 2023Copper Contributor
Thank you for your assistance, please see below. I'm Taking Paper Cost (R0.14) Plus B&W Printing (R0.05) it should give me Cost (R0.19). The "R" Is for the Rand, The currency in my Country. I have done this before, not sure why it won't work this time.
- LorenzoDec 30, 2023Silver Contributor
So you're doing exactly what I posted earlier: R0.14 isn't a Number, same goes with R.05. So logically when you add (multiply, substract...) these 2 Text values => #VALUE!
There's something to do IF the numbers you want to sum are always after R0.:
see attached sample
- BrandonS1973Dec 30, 2023Copper Contributor
Thank you again, I'm not sure why it doesn't work this time, as my previous ones I done were similar, with the "R" I hear what you are saying that Excl is seeing the "R" as a word, not part of the Sum.
Could you advise me going forward.
- SergeiBaklanDec 30, 2023Diamond Contributor
Since values are left aligned it looks like you entered them as texts, not applied currency format in Rands to numbers
Which formula you use it's not clear from the screenshot. Please stay on the cell which returns an error and share screenshot which shows the formula in formula bar.
Even better if you could share sample file.
- BrandonS1973Dec 30, 2023Copper Contributor