countif

C

chris

I am trying to use the countif statement to see how many
times Vault in column A and Inprocess come up together.
I cannot figure this out. The anwser should be 2 but I
cannot get anything but 4 which is how many times they
both come up seperately. I need it to count only how
many times both are true for a and b.
Thanks for any help.

a b
1 vault Inprocess
2 lockbox complete
3 incoding stared
4 vault Inprocess
 
A

Arvi Laanemets

Hi

=SUMPRODUCT((Vault=VaultValue)*(Inprocess=InprocessValue))
where Vault and Inprocess are data ranges (of same dimension).


Arvi Laanemets
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top