question re: SUMPRODUCT format

[Susan]

trying to learn this new function for me. on-line assistance shows
format should be:

=SUMPRODUCT(--(A2:A9="Active"), --(B2:B9>=10),--(C2:C9))
http://www.contextures.com/xlFunctions01.html
(to count the number of "active" with visits >=10 & sum the amounts in
column C)

this works & gives me the answer i want..........

===================================

another on-line site shows this format:

=SUMPRODUCT((array1)*(array2)* ...)
http://www.meadinkent.co.uk/xlsumproduct.htm

===================================

but when i Insert Function SUMPRODUCT, i get something
different:

=SUMPRODUCT(A2:A9="Active",B2:B9>=10,C2:C9)

but it doesn't give me the answer i get with the first formula.

===================================

can somebody please explain this to me? what's with the dashes in the
first formula? why does the 2nd formula use * as connectors?

does anybody else have a link to a better explanation of SUMPRODUCT?
thanks!
susan

 

[T. Valko]

See this:

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

 

[Susan]

thank you!
wading thru it - macros don't make my brain hurt this much!!!! (well,
maybe they did at first........). interesting that by multiplying
things it actually counts.

"This new array of 1/0 values is then multiplied by the array of
numbers sold to give another array of numbers sold that satisfy the
two test conditions. SUMPRODUCT then sums the members of this array to
give us a count."

thanks for that page - it explains it all very, very well.
susan

 

[T. Valko]

It's the definitive source on SUMPRODUCT.

Everything you always wanted to know about SUMPRODUCT.....

--
Biff
Microsoft Excel MVP


thank you!
wading thru it - macros don't make my brain hurt this much!!!! (well,
maybe they did at first........). interesting that by multiplying
things it actually counts.

"This new array of 1/0 values is then multiplied by the array of
numbers sold to give another array of numbers sold that satisfy the
two test conditions. SUMPRODUCT then sums the members of this array to
give us a count."

thanks for that page - it explains it all very, very well.
susan