LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 43
Default SUMPRODUCT arguments

Working with SUMPRODUCT for the first time. Can someone explain the use of
the dashes following the command? I've seen from none to (I think) 4...

I started with: SUMPRODUCT(--(range=x),--(range=y))

I am currently trying to use 3 arguments, but the answer I expected was +#,
but I am getting a -#.

SUMPRODUCT(---([RANGE S]="REPORT"),---([RANGE 1 DUE]=[FIRST OF THE
MONTH],---([RANGE 1 DUE]<=[END OF THE MONTH]))

The actual answer is 2, but I get -2.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Too few arguments plore Excel Worksheet Functions 5 July 19th 12 02:36 PM
IF-more than 7 arguments Carolina Excel Discussion (Misc queries) 3 May 20th 08 10:38 PM
And, if, arguments.... Chuck_in_Mo Excel Worksheet Functions 19 February 12th 07 03:42 PM
sumproduct to count two arguments [email protected] Excel Worksheet Functions 7 September 11th 06 03:18 AM
Can sumproduct do two {x,y,z} arguments? [email protected] Excel Worksheet Functions 3 April 14th 06 11:23 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"