View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gloriousglenn@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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