# 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

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

Report •

#2
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.GEK

Report •

#3
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

#4
June 24, 2010 at 08:04:46
 Hi,Just out of interest:SUM() will ignore text, as you found out, but some other functions in Excel do an implicit conversionEnter ="1" in A1 and="2" in A2Make 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 0but enter =A1+A2and the result is 3Regards

Report •

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

Report •