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

Try this:

=SUMIF(D1:D50,"Fuel",B1:B50)

Adjust the ranges to suit.

Hope this helps.

Pete

On Feb 4, 8:49*am, wrote:
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

Hi,

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

=SUMPRODUCT((MONTH(A2:A20)=MONTH(E1))*(D2:D20="Fue l")*(B2:B20))

Adjust the ranges to suit
Mike

" wrote:

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