Thread: SUMPRODUCT use of --() syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen Lloyd[_2_] Stephen Lloyd[_2_] is offline
external usenet poster
  
Posts: 48
Default SUMPRODUCT use of --() syntax
Thanks Mike, that was a great explanation.

"Mike H" wrote:

Stephen,

The use of Sumproduct and the double unary are explained here

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

Mike

"Stephen Lloyd" wrote:

I was wondering if someone could explain to me how the --() syntax works.
Also the use of SUMPRODUCT((condition1)*(condition2)).
Reply With QuoteReply With Quote