countif

  • Thread starter Thread starter chris
  • Start date Start date
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
 
Hi

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


Arvi Laanemets
 
You must log in or register to reply here.

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

sumproduct 2
checking two condtions 5
Excel Need Countifs Formula Help 0
countif - unique values only 8
Fallout 3 19
Help with countifs 1
Show me your highest mileage HDD? 0
Borderlands 2 18

Back
Top