Help!! Formula count /average


Posted by Marc on November 22, 2001 12:00 PM

I have 7 values that I want to count for example
3,38 ### 3,09 ### ### ### ### (###) are the outcome of another cel wich is the product of a formula.

Is it possible to count those seven values in anyway, or get the average of the seven values.

Please help

Posted by Gary Hewitt-Long on November 22, 2001 2:51 PM

What does ### mean?

Have you tried using the AVERAGE function.

e.g.

=AVERAGE(A1:A7)

Or have I mis-understood your question?

Regards,

Gary Hewitt-Long



Posted by Marc on November 22, 2001 8:55 PM

### means 0, there is nothing to display.