How to total only when 2 criteria are met?

Hi there,

the most common approach for a 1+ conditional formula is a SUMPRODUCT, so using your example:

=SUMPRODUCT(--($A$1:$A$100="C"),--($B$1:$B$100="min charge"),--($C$1:$C$100))

Important things to note with SUMPRODUCTS are each range must be of equal size (see 1:100) and they can not represent an entire row/column (ie can not use $A:$A or $1:$1), also your totals column (C) must contain only numbers.

You can also use Array formulae (entered with CTRL+SHIFT+ENTER), using the same example:

=SUM(IF($A$1:$A$100="C",IF($B$1:$B$100="min charge",$C$1:$C$100)))

Once array is confirmed the formula will become encased in {...}

SUMPRODUCTS tend to be used more than arrays as they are slightly more robust, if an end user adjusts an array formula they must remember to reset the array at the end (CTRL + SHIFT + ENTER) else the formula will cease to operate correctly - SUMPRODUCT does not require this action.

Here is a good web page outlining use of SUMPRODUCT and how it works etc...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH

Thanks for the prompt repy. I'll go away & have a play with your suggestions.
Thanks again.