Forum Discussion

Copper Contributor

Jul 31, 2018

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" ...

excel

Formulas and Functions

SergeiBaklan
Aug 01, 2018
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.

SergeiBaklan

Diamond Contributor

Aug 01, 2018

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.

Michael Morrow

Copper Contributor

Aug 01, 2018

Thanks, Sergei.

How would I go about converting to numbers instead of texts?

SergeiBaklan
Diamond Contributor
Aug 01, 2018
Formula in my previous post returns numbers, not text
- Michael Morrow
  Copper Contributor
  Aug 01, 2018
  Aha. I see now. For some reason, I was completely overlooking the quotes and your comment about removing them! Thank you!