COUNT IF FUNCTION
 

Hello, I am trying to countif a range of cells if they meet and certain
criteria and if another range meets a certain criteria.

I would like to count the # of times the score = 0 when the date = 1. I
tried this function =if(b1:b4=1,countif(d1:d4,0),0) however that returned
"0". Any ideas?


UM DATE CLAIM# SCORE
CKC 1 URL3763 0.00
CKC 1 UVN6314 0.00
CKC 5621 URI1126 1.00
CKC 1 UTR5794 0.00

COUNT IF FUNCTION
 

Use SUMPRODUCT: =SUMPRODUCT(--(B2:B5=1),--(D2:D5=0.00))

Dave
--
Brevity is the soul of wit.


"nperpill" wrote:

Hello, I am trying to countif a range of cells if they meet and certain
criteria and if another range meets a certain criteria.

I would like to count the # of times the score = 0 when the date = 1. I
tried this function =if(b1:b4=1,countif(d1:d4,0),0) however that returned
"0". Any ideas?


UM DATE CLAIM# SCORE
CKC 1 URL3763 0.00
CKC 1 UVN6314 0.00
CKC 5621 URI1126 1.00
CKC 1 UTR5794 0.00

COUNT IF FUNCTION
 

=SUM(IF((B2:B100=1)*(D1:D100=0),1))
or
=SUM((B2:B100=1)*(D1:D100=0))

Ctrl+Shift+Enter on both formula above, not just enter

"nperpill" wrote:

Hello, I am trying to countif a range of cells if they meet and certain
criteria and if another range meets a certain criteria.

I would like to count the # of times the score = 0 when the date = 1. I
tried this function =if(b1:b4=1,countif(d1:d4,0),0) however that returned
"0". Any ideas?


UM DATE CLAIM# SCORE
CKC 1 URL3763 0.00
CKC 1 UVN6314 0.00
CKC 5621 URI1126 1.00
CKC 1 UTR5794 0.00