| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a function that counts the amount of cells with information in them
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=549294 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| write a function to determine if cells have names | Excel Worksheet Functions | |||
Threaded Mode
