Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get a total for a year to date.
in doing my year to date sheet i of course don't have data yet for march-december and because of that my total colum shows as #div/0! the formula i am using reads as: =AVERAGE(JAN08!F44,FEB08!F44,MAR08!F44,APR08!F44,M AY08!F44,JUN08!F44,JUL08!F44,AUG08!F44,SEP08!F44,O CT08!F44,NOV08!F44,DEC08!F44) thank you in advance, |