Ignore error while using Countif function in excel

[ShreyaAnand]

I need to count number of times Cell B values are greater than Cell C in Sheet2 (attached sample sheet), but there are some errors in the data and hence Countif function is showing error. I cannot remove the error as it is needed to plot the graph.

I need to fill this data in yellow colored cell.

Please help me out!

Thanks in advance!

 

[Luke M]

Can you make a helper column in col D?
Formula of:
=B3>C3

Then your COUNTIF formula is:
=COUNTIF(D3:D8,TRUE)

 

[Chihiro]

Here's another method.

Nest VLOOKUP() in IFERROR(,"") and in G3.
=SUMPRODUCT((B3:B8>C3:C8)*(ISNUMBER(B3:B8))*(ISNUMBER(C3:C8)))

 

[Deepak]

One more CSE

=SUM(--(IFERROR(B3:B8>C3:C8,0)))

 

[ShreyaAnand]

Thank you so much! It works now!