SUMIF with Multiple Columns and a Need to Exclude

[Boudreau]

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.

[chataylo]

Try

=SUMIF(A:A,"4001111",C:C)-SUMIFs(C:C,A:A,"4001111",B:B,"Technical Training")

Cheers,
Chataylo

[Boudreau]

Brilliant. Worked perfectly.

Thank you!

[ConneXionLost]

Or this:

=SUMIFS(C:C,A:A,"4001111",B:B,"<>"&"Technical Training")

Cheers,

[Jonmo1]

Try
=SUMIFS(C:C,A:A,"4001111",B:B,"<>Technical Training")