Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to count the cells that have text but are not "". I understant that
counta() will count all non empty cells but "" is not the same as empty. I have tried =counta(field,"<""" and variations but cannot get the proper result. dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CountA formula with an IF statement | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |