If the target cells don't fall into some sort of pattern, you'll need to
use the technique described by Peo. If they do fall into some sort of
pattern, an alternative may be available.

In article ,
Katrina C. wrote:

The problem is that it is some of the cells in a column but not all of them
and when I try to put them in individually I am over my limit of values or
arguements. I did not set this spread up so the columns are not as I would
have them but there are three differented questions in each column with a
numberic rating and the averages are in three cells below the column.
Because it is not the whole column, I believe that I have to enter the cell
locations individually which makes me have too many values for Counta or
daveragea and I believe there is a way around this to give me the average of
the ratings for each question.

I hope that is clear. I am not very good about explaining something. I
would just count the cells but there is alot and this is done on a regular
basis.

Thank you for all the help you can provide.

Katrina C.

"Domenic" wrote:

Which cells do you wish to average?

In article ,
Katrina C. <Katrina wrote:

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.