IF equation multiple Rows

July 28, 2011 at 10:56:38
Specs: Windows XP
I am attempting to create an equation that will refer to Column A, and if it has the correct text, then it will include the number in Column C in a sum formula. For the moment, because I do not have that many rows, I've been using this:


This formula is working exactly like I want it to, except that I don't want to have to add A4, A5, A6, etc to the formula. I keep feeling like I'm getting really close to the solution, but then it slips away. Is there any way I can have the formula automatically check each row within Column A for the specific word, and only use the correct Column Cs in the Sum? Thanks so much.

See More: IF equation multiple Rows

Report •

July 28, 2011 at 11:21:07
Are you looking for this?


You should read up on the SUMIF function in the Excel help files to help yourself understand how it works.

If you are using Excel 2007 or later, you should also read up on SUMIFS.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 28, 2011 at 11:25:39
That's it. I completely blanked on SUMIF. Thank so much!

Report •

Related Solutions

Ask Question