| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a function that counts the number of cells with information
Is there such a function that counts the amount of cells with information in them. For example right now Im trying to find this so I can find an average. So Im wanting to divide the autosum by the number of cells with information. The numbers that make up the autosum have blank cells in between them, so i cant just count the number of cells; i need the number of cells with information on them. I hope you understand what Im asking for. Tell me if u want me to explain more. Thanks -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=549291 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
