Thread: countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris[_8_] chris[_8_] is offline
external usenet poster
 
Posts: 1
Default countif

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