count function

[giri ravirrala]

hi,
i am not able to get count value at H16 cell for the selected range(H3:H15 having the range formula =IFERROR(INDEX($C$3:$C$19,MATCH(0,COUNTIF($H$2:H2,$C$3:$C$19)+($B$3:$B$19<>$G$3),0)),"")

please find the attached sheet, please help me...

regards,
giri.

 

[Nunes]

Hi!

The problem is that your "Lot No" column H is being evaluated as text and text is not counted by COUNT().

You can replace the formula in H16 by
=COUNT(VALUE(H3:H15))

and enter it with Ctrl-Shift-Enter.

Hope it helps
Best

 

[Ramesh]

You can use the following formula:

=COUNTIF($H$3:$H$15,"*?")

This function returns 10 as output as the formula written in H3:H15 returns output for 10 cells out of total 13.

The criteria expression "*?" in Countif function counts a range that contains a formula and either returns text or "" (blanks)

 

[Khalid NGO]

Hi giri and all,

another could be:
=SUM(IFERROR(SIGN(H3:H15),))
with CSE

Regards,

 

[giri ravirrala]

thank you all