Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create an if statement that looks for a specific cell color? | Excel Worksheet Functions | |||
an if( statement looking for a specific phrase anywhere in a cell | Excel Worksheet Functions | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
Search for a specific character in a cell in an if statement | Excel Worksheet Functions |