I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Sumif
20091024_PB_01_Sumif

Similar to Countif naive souls are happy with Sumif if they only need to apply one condition.

Please see my example on the left.

20091024_PB_02_Sumif

But as soon as you face two or more conditions which you want to apply with logical AND's or OR's, you are in trouble again.

SUMPRODUCT is your solution here.

The example on the left shows the sum of all Ford cars from USA (2,000 - this a logical AND) and the sum for all cars which are a Ford or from USA
(11,400 - this is a logical OR).

Please note that I suggest NOT to take SUMPRODUCT as a holy grail. I use this example just as an evolutionary argument. Please read additional material on SUMPRODUCT here.

Sulprobil   Get it done   Contact   Disclaimer   Download