Countif in an ARRAY.
 

I want to count the number of instances that C2:C487 is equal to G A and
where the numbers in cells E2:E487 are greater than the numbers in cells
F2:F487. I
|=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}.

Countif in an ARRAY.
 

I can read your question more than one way, but I am pretty sure this
formula does what I think you intended to ask for...

=SUMPRODUCT(($C$2:$C$487="G A")*($E$2:$E$487F2:F487))

Rick


"SW" wrote in message
...
I want to count the number of instances that C2:C487 is equal to G A and
where the numbers in cells E2:E487 are greater than the numbers in cells
F2:F487. I
|=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}.

Countif in an ARRAY.
 

One way, normal ENTER:
=SUMPRODUCT(($C$2:$C$487="G A")*($E$2:$E$487F2:F487))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SW" wrote:
I want to count the number of instances that C2:C487 is equal to G A and
where the numbers in cells E2:E487 are greater than the numbers in cells
F2:F487. I
|=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}.