Forum Discussion
A Little Help with AutoSum
I'm not the most proficient with Excel, so please be patient. In a nutshell, I have inserted an IF statement in a cell like this:
=IF(E64="Resize","5","10")
As a result, if I type in "Resize" into one cell, it autogenerates a 5 in the adjacent cell. If I type anything else, it places a 10. So the range looks something like this:
New 10
New 10
Resize 5
New 10
I then try to autosum the numbers, but it won't work. It only delivers a value of 0. My only functional workaround is to click each cell and then the plus sign and then the next cell and the plus sign and so on until I'm done. Very tedious.
Hopefully someone knows a way for me to autosum this column when I'm done entering data. Much appreciated.
Hi Michael
SUM function ignores text and logical TRUE/FALSE, it sums only numbers in the range. Since you have text only it returns zero. You may convert your formula as
=IF(E64="Resize",5,10)
to return numbers 5 and 10, not texts "5" and "10", you'll be able to calculate the sum.
4 Replies
Hi Michael
SUM function ignores text and logical TRUE/FALSE, it sums only numbers in the range. Since you have text only it returns zero. You may convert your formula as
=IF(E64="Resize",5,10)
to return numbers 5 and 10, not texts "5" and "10", you'll be able to calculate the sum.
Thanks, Sergei.
How would I go about converting to numbers instead of texts?Formula in my previous post returns numbers, not text
