CMAC

Posts: n/a

how to disregard the DIV in a range

2 questions

how can i get a sum formula to return a reslut when there are DIV errors in
the range?

and what does the "--" mean in this formula?
=SUMPRODUCT(--($C$11:$C$36="n"),($D$11:$D$36*P$11:P$36))

Help is greatly appreciated

c

Reply With Quote

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
ClearContents method on a passed range	bryan	New Users to Excel	2	January 19th 05 08:49 AM
range names	Pedro	Excel Worksheet Functions	2	January 18th 05 03:38 AM
Defined range difficulty	Pat	Excel Discussion (Misc queries)	7	January 16th 05 09:52 PM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM
range names	Pedro	Excel Worksheet Functions	0	November 9th 04 06:26 PM

All times are GMT +1. The time now is 03:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us