totaling a column with IF results

Microsoft Office excel 2007 home & stude...
June 23, 2010 at 18:48:09
Specs: Windows 7, Its a brand new HP PC
Each cell in column B uses an IF function based on column A.
=IF(A6>15,"5",IF(A6>7,"4", IF(A6>3,"3",IF(A6>1,"2","1")))) It works great.
I now need to add all those numbers in the column, but the =sum function doesn't work. It gives me "13" instead of "1456".

See More: totaling a column with IF results

Report •

June 23, 2010 at 19:44:01
Lose the quotes and see what happens.

Report •

June 24, 2010 at 07:50:28
Thank you, thank you, thank you! Removing the quotes fixed it. I've never posted a question online before, but I couldn't find anyone around here who knew what was wrong. Thanks again.

Report •

June 24, 2010 at 07:54:23
When you use the quotes, Excel turns the numbers into text strings, which it can't SUM.

I'm glad I could help out. Come on back if you have any other questions, but please make sure you create a new thread if your questions are not related to this one.

Report •

Related Solutions

June 24, 2010 at 08:04:46

Just out of interest:
SUM() will ignore text, as you found out, but some other functions in Excel do an implicit conversion

Enter ="1" in A1 and
="2" in A2
Make sure you enter the = sign and the quotes.
This puts 1 and 2 as text in the two cells.

In another cell enter =SUM(A1:A2)
The result is 0
but enter =A1+A2
and the result is 3


Report •

June 24, 2010 at 08:16:04
Good to know.


Report •

Ask Question