You're welcome.

Pete

On Nov 11, 1:55*am, Need help with sumif
wrote:
Thank you for the details



"Pete_UK" wrote:
If you have more than one criteria then you can't use SUMIF - use
SUMPRODUCT instead. If you are using XL2003 or earlier then you can't
use full-column references with SP, and it is better to keep the
ranges just as large as required to cover your data. Something like
this:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=50%),C1:C100)

The -- converts True and False to 1 and 0 respectively for each
element. Another way of writing it is:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%),C1:C1 00)

or even:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

where * is equivalent to AND.

Hope this helps.

Pete

On Nov 11, 1:19 am, Need help with sumif
wrote:
How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C

Let me know if there is other solution other then SUMIF also- Hide quoted text -

- Show quoted text -