Access to 106 free guest articles, discussions and more, just create your free OfficeUsers User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

When Excel�s AVERAGE function doesn�t give true results, try AVERAGEA

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

Article Abstract:

(Mary Ann Richardson) Sometimes, the AVERAGE function does not give a true picture of your data. AVERAGE can only find the average of a range of numerical values; it skips any text values. For example, the results of a monthly mailer for donations to a nonprofit organization are listed below. If you want to know the amount of the average donation that came in, you would use the AVERAGE function, as shown in B20. The results would not include those who received the mailing but did not send a donation.

Read this article...

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback

[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2009, Bits on the Wire, Inc.

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.