a function that counts the number of cells with information

Z

zuri125

Is there such a function that counts the amount of cells wit
information in them. For example right now Im trying to find this so
can find an average. So Im wanting to divide the autosum by the numbe
of cells with information. The numbers that make up the autosum hav
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 t
explain more.
Thank
 
V

VN

The AVERAGE function can give you the corect result , even if it will
have blank in your range.


or you can this formula to counts the amount of cells with information
in them.

This formula for counting cell that stored any information .
=SUMPRODUCT(--NOT(ISBLANK(A1:A10)))


This formula for counting cell that stored number only.
=SUMPRODUCT(--ISNUMBER(A1:A10))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a function that counts the amount of cells with information in them 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Is there a function to count how many times a cells value is used? 0
vlookup or some other function that counts rows 0
Not having luck with any examples of averaging... 2
Page numbering with Merged Document and IF statements 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Using sumproduct function to count cell values on a remote workbook 3

Top