How do I calculate average with more than two cells?

M

macropod

Hi Melinda,

The same as you would for a table with one or two cells - with an AVERAGE formula. For example, if the figures are in a given
column, a formula field coded as {=AVERAGE(ABOVE) \# ",0.00"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.
 

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

Cell data entering slow! 0
How to create a bubble chart with more than 2 variables. 0
How to open multiple instances of Word 365? 5
multiple conditions 8
Standard Deviation and Averages based on criteria 2
calculate average values for 100 records in the shortest way? 5
Excel 2007 average formula 4
=AVERAGE (see underlying values?) 7

Top