Conditional formula help

[leung115]

Hi there ... I'm trying to create a budget sheet (even though there are millions of templates out there :D) and can't seem to figure out how to make this work. It should be quite simple for some experts in this forum, so here goes:

I have Expenses in A1, A2, A3 ... all the way to A12. I have a set budget number in B2 ... A12. From C2 - C12, I have the actual amount expensed.

Starting at A20 to A300, I will be listing the expense (e.g. car payment, insurance payment etc.), and in C20 to C300 I will be including the amount expended.

Basically, what I want is in cells C2 to C12 to pull the value from C20 to C300 based on the text value in A20 to A300. So for example, under A2 I have car payment. I would like to enter a formula in C2 that says "if any cell from A20 to A300 equals "car payment", then C2 will equal the corresponding same C row from C20 to C300" Does that make sense? It does in my head hahaha

So I've got up to this point =IF(ISNUMBER(MATCH("car payment",$A$20:$A$300,0)),[I DON'T KNOW WHAT GOES HERE],0)

Help would be greatly appreciated, thank you!

[daffodil11]

=sumif(A20:A300,"car payment",C20:C300)

OR

=SUMPRODUCT((A20:A300="car payment")*(C20:C300))

[leung115]

=sumif(A20:A300,"car payment",C20:C300)

OR

=SUMPRODUCT((A20:A300="car payment")*(C20:C300))

Thanks! I used the first one.

[daffodil11]

There's also SUMIFS, where the parameters are SUMIFS(sum what, criteria range1, criteria1, range2, crit, etc)

SUMIFS can sum A where B = x, C = y, D = z, E = red, etc.