Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
High you all,
I need a single formula that gives me, for a rectangular area, the number of rows that have at least one non blank cell. Say, for example, that in A1:M20 all the cells are blank except B10 contains "X" F10 contains 9 C15 contains "X" The result is 2, because only 2 rows, numbers 10 and 15, contain some data I have been able the get the correct figure using intermediate results. What I need now is a single formula that gives me the final result directly. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How inserer a certain number of blank rows | Excel Discussion (Misc queries) | |||
To delete rows when more than one cell is blank | Excel Worksheet Functions | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Hiding Rows if Blank cell | Excel Worksheet Functions |