Counta or daveragea functions
I am doing a worksheet that needs to count the non-blank cells to average the
information in the cells. I am having a problem because the cells are not so
I can enter a range but must enter each cell individually. Or at least as
far as I know the the Counta and the daveragea functions will only work with
30 values or arguements. I am sure there is a way around this limit. I am
pretty sure of it but do not know how. Could someone help me with this?
I thank any help I get in advance.
|