#### excelindianfanclub

##### Board Regular

- Joined
- Oct 20, 2012

- Messages
- 64

I need a clarification regarding Countif function for the following sample data of mine

I | J | Formula | ||

5 | Numeric Value | 111 | ||

6 | Numeric Value stored as text | 111 | '111 | |

7 | Date | 18 May 2003 | ||

8 | Double quote blank | ="" | ||

9 | Character space | =CHAR(1) | ||

10 | Empty cells | |||

11 | Error Values | #N/A | =NA() | |

12 | Formula resultant blank | =IF(5<3,"Yes 5<3","") | ||

13 | Text | asas | ||

14 | Numeric Value enclosed in double quotes | 1 | ="1" | |

17 | Non Empty Cells | 10 | =COUNTIF(J5:J14,"<>""") | |

18 | Non Empty Cells | 9 | =COUNTIF(J5:J14,"<>"&"") | |

19 | Non Empty Cells | 7 | =SUMPRODUCT(--IFERROR(--(J5:J14<>""),1)) |

<colgroup><col span="2"><col><col><col></colgroup><tbody>

</tbody>

i want to count the non blank cells.i used the

**countif**function but it is giving wrong answer.Even i though i got the correct answer using sumproduct.i need a clarification why Countif unable to count Non blank cells.is there correction needed in my formula?.i need a explanation for the above countif functions which i have used.How the Countif function worked in my case?.Please help me.Im going to burst if im not getting the reason.Thanks in advance