Microsoft Office excel 2007 home & stude...

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

Lose the quotes and see what happens.

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

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.

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

Good to know. Thanks

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History