Microsoft Office 2007 home and student

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???

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

Hi, This looks like a homework assignment !

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

Regards

Thank you "DerbyDad03" this formula was perfect!!! :)

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History