be great, but a description is fine too. What data needs to be
computed? How is the data entered in the source sheet? What does your
pivot layout look like? Email me off list if you need to send the
screen shots. Thanks.
MARK DEEGAN | Director of Instructional Technology | (301) 257-2217 |
mdeegan@fs-dms.org
THE FOUNDATION SCHOOLS | 6000 Executive Blvd., Suite 605 Rockville, MD
20852 | www.foundationschools.org
> -----Original Message-----
> From: A forum for independent school educators [mailto:ISED-
> L@LISTSERV.SYR.EDU] On Behalf Of Brenda Rilling
> Sent: Monday, June 08, 2009 9:43 AM
> To: ISED-L@LISTSERV.SYR.EDU
> Subject: Any excel pivot table experts out there?
>=20
> Greetings!
>=20
> Forgive the unusual request on this listserv, but Excel is driving me
> crazy! (short trip, actually).
>=20
> 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
> =3Daverage() formula.
>=20
> Any ideas?
>=20
> Thanks,
>=20
> Brenda
>=20
> 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
>=20
> [ 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=3DISED-L
=0D
NOTICE: This message is intended only for the use of the Addressee(s) and m=
ay contain information that is PRIVILEGED and CONFIDENTIAL. If you are not =
the intended recipient, dissemination of this communication is prohibited. =
If you have received this communication in error, please erase all copies o=
f the message and its attachments and notify me immediately. We have made =
all reasonable efforts to ensure that this email and any attachments are fr=
ee from viruses but it is the responsibility of the recipient to carry out =
all necessary virus checks and the "company" accepts no liability in connec=
tion therewith. Thank you.
[ 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=3DISED-L
