Forum Discussion

BrandonS1973's avatar
BrandonS1973
Copper Contributor
Dec 30, 2023

I'm a New User having issues with a simple Sum

Hi All   Im trying to do a simple pricelist in Excel.    Item A + Item B = AB, i now get #Value!   I have done a few of these before on my Work PC, I have a new one to do work at home, now I'm ...
office 365
BrandonS1973's avatar
BrandonS1973
Copper Contributor
Dec 30, 2023

Lorenzo 

 

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.

 

 

Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 30, 2023

BrandonS1973 

 

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

  • BrandonS1973's avatar
    BrandonS1973
    Copper Contributor
    Dec 30, 2023

    Lorenzo 

     

    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. 

Resources