Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))
 

I find it difficult to get results for getting a formula. Please help

Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))
 

Hi!

Try this:

=SUMPRODUCT(--(A3:A200=100000),--(B3:B200="Y"),--(C3:C200="Z"))

Biff

"Prasad" wrote in message
...
I find it difficult to get results for getting a formula. Please help

Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))
 

"Prasad" wrote:
I find it difficult to get results for getting a formula. Please help

Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))

Think this expression using sumproduct would work for you:
=SUMPRODUCT((A3:A200=100000)*(B3:B200="Y")*(C3:C2 00="Z"))

Note: Criteria syntax corrected in the above. Wrap double quotes only for
text strings, remove the double quotes wrap for numbers (otherwise it'll be
taken as text)

Btw, pl do not rely solely on the subject line to comm your entire query.
Always post your entire query, details & all, clearly within the message area.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---