Forgive the unusual request on this listserv, but Excel is driving me
crazy! (short trip, actually).
I am trying to do a pivot table using averages. However, Excel won't do
the calculations if there are empty cells as part of the calculation. I
don't want to fill in 0's, I just want it to take the average of the other
cells and ignore the empty one, as it would normally do in a regular
=average() formula.
Any ideas?
Thanks,
Brenda
Brenda Rilling
IT Director
Selwyn House School
95 Cote St. Antoine
Montreal, QC H3Y 2H8
(p) 514-931-9481 x 2281
(f) 514-931-6118
[ For info on ISED-L see http://www.gds.org/ISED-L ]
Submissions to ISED-L are released under a creative commons, attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=ISED-L
