Hi,
Using what if formula, to arrive at values in their respective column
Then want to simply add up, using Sum, the range of cells in the column
Got it to work on some columns, but not others
Very strange- have you come across this
2 screen shots- On the cell with the If calc, the other showing the sum calc
Thanks in advance if you think you can help
MacBook Pro 15″, macOS 12.6
The numeric functions such as SUM ignore text, even text that is all number characters. The quotes around "1" in your formula =IF(K3=-0,"1","-") formats the 1 as text. Try this instead:
=IF(K3=0,1,"-")
I assume you did the same thing in other formulas so you might need to change them also if you will be using numeric functions on them.
The numeric functions such as SUM ignore text, even text that is all number characters. The quotes around "1" in your formula =IF(K3=-0,"1","-") formats the 1 as text. Try this instead:
=IF(K3=0,1,"-")
I assume you did the same thing in other formulas so you might need to change them also if you will be using numeric functions on them.
Thank you so very much, you're a star...that has done the trick and I am very grateful for your help
Deleted as my reply was the same as Badunit's.
By the way, I don't understand -0
Do you mean <=0?
Ian.
As bad unit notes, adding text may be confusing. Try changing the formula from:
=IF(K3=-0,"1","-")
To:
=IF(K3=0, 1 ,"-")
Numbers not adding up Can you Help Please
