Posted to microsoft.public.excel.programming

Gary Keramidas[_2_] Gary Keramidas[_2_] is offline

external usenet poster

Posts: 364

how can i adapt this formula?

=SUM(IF(NOT(ISERROR(C6:H6)),C6:H6),0)

i need to skip column D

--

Gary

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
Help to adapt Formula syntax to work with Visible Filtered Cells	Sam via OfficeKB.com	Excel Worksheet Functions	6	September 16th 05 11:42 PM
Help to adapt Formula syntax to work with Dynamic Named Ranges	Sam via OfficeKB.com	Excel Worksheet Functions	13	April 29th 05 12:36 AM
adapt macro	monty	Excel Worksheet Functions	3	March 9th 05 12:44 PM
Please help me to adapt this code.	Rob Hargreaves	Excel Programming	1	February 2nd 05 08:27 PM
Trying to adapt progress meter	hotherps[_144_]	Excel Programming	0	October 17th 04 02:46 PM

All times are GMT +1. The time now is 01:20 AM.

About Us

"It's about Microsoft Excel"