#DIV/0!
On Mar 8, 4:04 pm, "Jim S" wrote:
OK, This is the formula that I have that is pulling data from all pages of a
multipage document
AVERAGE(ESP1!F24+ESP2!F24+LV!F24+LA!F24+RAT!F24+SF 1!F24+
SF2!F24+SF3!F24+TAO*S!F24)/9
First of all, you probably want:
AVERAGE(ESP1!F24,ESP2!F24,LV!F24,LA!F24,RAT!F24,SF 1!F24,SF2!F24,SF3!
F24,TAO*S!F24)
AVERAGE() will accept up to 30 arguments in this form.
some of the cells in this formula are at 0 until data
is entered and other cells have data
Then I suspect you have a serious problem either with the format of
those cells or with the cell references.
AVERAGE() probably returned #DIV/0! because AVERAGE() thinks that all
the cells are blank or contain non-numeric values (e.g. text). If the
cells __appear__ to have numeric values, check their formats.
|