sumproduct
 

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

sumproduct
 

Chris,

Just add the condition to the sumproduct ie.

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

Dan E

"Chris....." wrote in message ...
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

sumproduct
 

Chris,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Chris....." wrote in message
...
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