ExcelBanter - Specific IF statement problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Specific IF statement problem (https://www.excelbanter.com/excel-discussion-misc-queries/175454-specific-if-statement-problem.html)

[email protected]

Specific IF statement problem

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

Specific IF statement problem

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

Mike H

Specific IF statement problem

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

All times are GMT +1. The time now is 07:02 PM.