Specific IF statement problem

[gloriousglenn]

Hi all!

I have a spreadsheet for my banking and one worksheet has all of my
credit card debits and credits on it (Column A - Date, B - Amount, C -
Merchant etc).

I want to figure out how much I'm spending on fuel for my car each
month, so I put a comment in column D saying "Fuel" whenever I've made
a fuel transaction.

Now what I would like, is a cell at the bottom to add up all of the
entries in Column B (Amount) only if Column D has the word "Fuel" in
it.

I hope I have explained this well enough!

Any help would be appreciated.

Best regards
Glenn

 

[Pete_UK]

Try this:

=SUMIF(D150,"Fuel",B1:B50)

Adjust the ranges to suit.

Hope this helps.

Pete

 

[Mike H]

Hi,

Put a date in E1 that is the month you want to sum for and try this

=SUMPRODUCT((MONTH(A2:A20)=MONTH(E1))*(D220="Fuel")*(B2:B20))

Adjust the ranges to suit
Mike