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