Hi
It didn't work, it gives the same result ( incorrect numbers)


"Pranav Vaidya" wrote:

change your formula as

=COUNT(IF((TRIM($C$4:$C$100)="C")*(TRIM($M$4:$M$10 0)<"Closed"),$A$4:$A$100,0))

You were missing the last part of the IF condition, which I added as 0
(zero) in the above formula.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"ub" wrote:

Hi
I am using this formula to count
=COUNT(IF((TRIM($C$4:$C$100)="C")*(TRIM($M$4:$M$10 0)<"Closed"),$A$4:$A$100))
I am not getting the right results, because column $m$4:$m$100 has blank
cells , so this formula is counting the blank cells.
Please advise how can I correct this formula that is considers blank cells
in coulmn M.

Thanks