Posted to microsoft.public.excel.misc

external usenet poster

Posts: 48

How to limit sum function to numeric values

How do I add a group of cells but ignore any cell with a value of "na"?

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return Numeric Labels that have different Numeric Values	Sam via OfficeKB.com	Excel Worksheet Functions	8	December 3rd 06 02:06 AM
Non Numeric Values	Harry Hornet	Charts and Charting in Excel	1	November 3rd 06 05:08 PM
Matching numeric values.	mohd21uk via OfficeKB.com	Excel Discussion (Misc queries)	1	May 17th 06 02:40 PM
How to average every 10 numeric values	emel24	Excel Worksheet Functions	4	August 11th 05 08:29 AM
Text values to numeric values	jayveejay	Excel Discussion (Misc queries)	1	August 10th 05 05:03 PM

All times are GMT +1. The time now is 05:22 AM.

About Us

"It's about Microsoft Excel"