Forum Discussion
Solved
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" ...
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
Aha. I see now. For some reason, I was completely overlooking the quotes and your comment about removing them! Thank you!