Excel Formula - Conditional Sum

Microsoft Office 2007 home and student
January 9, 2010 at 23:36:48
Specs: Windows 7
I have set up a budgeting type of project in excel, I'm trying to find the perfect formula to complete a task. Example for the task:
Cell A1 needs to calculate the sum of C1:C100 only if the cell has the word "Food" in it, if the word food is in one or more of these multiple cells than A1 needs to take the number from cells "B1:B100" that is directly next to the cell with "Food" and give a total sum of them... Does this make sense?? If so can you help???

See More: Excel Formula - Conditional Sum

Report •

#1
January 10, 2010 at 04:44:09
Please read up on the SUMIF formula is Excel Help.

=SUMIF(C1:C100,"=Food",B1:B100)

re: Cell A1 needs to calculate the sum of C1:C100 only if the cell has the word "Food" in it,

I think I know what you are asking for, but you can't Sum C1:C100 if C1:C100 contains text. The formula above will Sum the cells in B1:B100 where the corresponding cell in C1:C100 contains the word Food (and only the word Food).


Report •

#2
January 10, 2010 at 04:44:20
Hi,

This looks like a homework assignment !

What formulas have you tried so far, that have turned out to be not quite perfect.

Regards



Report •

#3
January 10, 2010 at 13:38:12
Thank you "DerbyDad03" this formula was perfect!!! :)

Report •
Related Solutions


Ask Question