| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for counting number of cells
Dear All,
I have a range of cells, say A1 to A50. I want to write a formula in cell A51 which will display the number of cells in the range which contain the data (which are not blank). e.g. if only A1 to A5 cells contain some data and other cells are blank, then it should show 5 as the result. The data can be either text or numbers. Is it possible? Thank you in advance. Regards, Pawan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
