Would appreciate any assistance with this one:
Column A lists Account #s. Column B lists a Description. Column C lists the Expense amount.
My current formula =SUMIF(A:A,"4001111",C:C) works fine for giving me a total of all Expenses within that Account #.
What I need to do, is make it so that the all of the Expenses except for "Technical Training" (Column B Description) are calculated.
Example:
4001111 Travel $100
4001111 General $100
4001111 Details $100
4001111 Vehicle $100
4001111 Technical Training $500
The computation needs to result in $400 rather than $500. The Technical Training Expenses are extracted using a sumif function already and I need to avoid double-counting later in this particular process.
This data is in a listing that changes daily and will not remain in the same cells-- hence the need for the sumif function.
Thank you.
Bookmarks