Posted to microsoft.public.excel.worksheet.functions

Poody

Posts: n/a

sumproduct question - kind of...

I needed a formula (that I was able to find on this group, btw). The formula
from the gropu was:

=sumproduct(--(B2:B10=1),--(F2:F10="Completed"))

My question is, what does the -- do, and can I find more information about
this in the help files? If it is in help, what is it called, as I haven't
been able to find anything about it - even when looking at the sumproduct
help information.

Thanks,

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
Sumproduct Question	[email protected]	Excel Discussion (Misc queries)	9	March 10th 06 04:26 PM
Pivot Table Question - KIND of UrgentTh	[email protected]	Excel Discussion (Misc queries)	1	February 15th 06 09:05 PM
Question about sumproduct	Jason	Excel Discussion (Misc queries)	1	April 21st 05 05:44 PM
Question about sumproduct	bj	Excel Discussion (Misc queries)	0	April 21st 05 05:40 PM
sumproduct question	taxmom	Excel Worksheet Functions	3	April 18th 05 07:01 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us