#1   Report Post  
Peter B
 
Posts: n/a
Default Sumproduct

I have used the sumproduct function a lot and thinks it is very good. My
problem is that I do not know the functions of different characters that can
be used in the sumproduct function

Ie. what is the "--" in front of a sumproduct function : "Sumproduct(--(xx
and when to use "*" and "+" and ",".

Does anyone have any "guide" to sumproduct that can explain theese things
and probably other things?



--
Peter B
Norway
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

For an explanation of the double unary usage, see:

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

and

http://tinyurl.com/5fvwo

To learn about SUMPRODUCT, see:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I have used the sumproduct function a lot and thinks it

is very good. My
problem is that I do not know the functions of different

characters that can
be used in the sumproduct function

Ie. what is the "--" in front of a sumproduct

function : "Sumproduct(--(xx
and when to use "*" and "+" and ",".

Does anyone have any "guide" to sumproduct that can

explain theese things
and probably other things?



--
Peter B
Norway
.

Reply
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
sumproduct causing memory errors? dave Excel Worksheet Functions 1 March 3rd 05 09:31 AM
Can I reference =, <, or > sign in SUMPRODUCT BobT Excel Discussion (Misc queries) 7 February 16th 05 01:58 PM
Sumproduct ... Empty Cells vs Spaces? Ken Excel Discussion (Misc queries) 9 December 17th 04 08:03 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


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

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"