Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know that I'm doing something wrong, because this has to be easier
than I'm making it out to be. In a column of data from G1:G218, I have some text based information. They info is grouped, as such, there are empty/blank cells in column G where the groupings change. Using COUNTA(G1:G218) = 215 Using COUNTBLANK(G1:G218) = 15 Which makes me think that the number of populated cells is 203 which I get by taking 218 (all cells) and subtracting 15 (the countblank answer). What am I missing here? What does the 215 represent from the COUNTA formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confusion with Names | Excel Discussion (Misc queries) | |||
Button Confusion | Excel Discussion (Misc queries) | |||
Confusion..... | Excel Discussion (Misc queries) | |||
Chart confusion | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |