OK, This is the formula that I have that is pulling data from all pages of a
multipage document and some of the cells in this formula are at 0 until data
is entered and other cells have data, how do I add the IF option to this
formula?

AVERAGE(ESP1!F24+ESP2!F24+LV!F24+LA!F24+RAT!F24+SF 1!F24+SF2!F24+SF3!F24+TAOS!F24)/9

--
Jim Salyer
Area Supervisor
Home 505-474-4863
Mobile 505-670-4138
Fax 505-474-4540
"Jim S" wrote in message
...
What does #DIV/0! mean when it shows up in a cell with a formula?

--
Jim S