sumproduct

[Chris.....]

I am currently using sumproduct to count how many
times "vault" and "complete" show up together in colum A
and B. the following combination come up below.

=sumproduct((A1:A5="Vault")*(B1:B5="complete")) giving me
the correct answer of 3. How do I place a third criteria
on it to count all of the Vault, completes that are under
100?
a b c
1 Vault complete 100
2 lockbox late 50
3 vault complete 50
4 branch in process 100
5 Vault complete 200

Thanks for all of your help in advance. This forum is
incredible for us average users...Thanks again!!


6

 

[Dan E]

Chris,

Just add the condition to the sumproduct ie.

=SUMPRODUCT((A1:A5="Vault")*(B1:B5="complete")*(C1:C5<100))

Dan E

 

[Chip Pearson]

Chris,

Try

=SUMPRODUCT((A1:A10="vault")*(B1:B10="complete")*(C1:C10<100))