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 getting an issue. My Cells look correct. I have gone thru all the settings, auto calculate is on, I don't know what else to look for. I'm sure it's a setting as i have not had an issue before. I'm fairly new to Excel and still learning.

 

Thank you for your time. 

office 365
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 30, 2023

    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?

    • 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

Resources