sumproduct

  • Thread starter Thread starter Chris.....
  • Start date Start date
C

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
 
Chris,

Just add the condition to the sumproduct ie.

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

Dan E
 
Back
Top