Calculating the average of cells

P

pippa

I am trying to use a formula to calculate the average of random cells
currently containing data, however also including cells where data will be
added at a later date but remain empty. Is this possible?
 
S

SteveW

I am trying to use a formula to calculate the average of random cells
currently containing data, however also including cells where data will be
added at a later date but remain empty. Is this possible?
Click to expand...

=average(<range1>,<range2>...)

will work quite happily with blanks and non numeric values
but will not accept cells with calculation errors (not a problem if
all your cells are just data)
 
P

pippa

Many thanks Steve

SteveW said:
=average(<range1>,<range2>...)

will work quite happily with blanks and non numeric values
but will not accept cells with calculation errors (not a problem if
all your cells are just data)
Click to expand...
 

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
Calculating averages and not including blank cells 1
Display weeks from a Milestone 0
Formula within Pivot Table Calculated Field - Days in time period 0
Ignoring Blank cells 9
MS Project. Real progress of the project, % complete 1
Standard Deviation and Averages based on criteria 2
A useful AVERAGE calculation without using the built-in AVERAGE function 3

Top