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: =SUM(IF(A2="Text",C2,0),IF(A3="Text",C3,0))

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.

Are you looking for this? =SUMIF(A2:A5,"=Text",C2:C5)

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.

That's it. I completely blanked on SUMIF. Thank so much!

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History