question SUMPRODUCT format
 

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

question SUMPRODUCT format
 

See this:

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

--
Biff
Microsoft Excel MVP


"Susan" wrote in message
...
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

question SUMPRODUCT format
 

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



On Jan 17, 3:05*pm, "T. Valko" wrote:
See this:

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

--
Biff
Microsoft Excel MVP

"Susan" wrote in message

...



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- Hide quoted text -

- Show quoted text -

question SUMPRODUCT format
 

It's the definitive source on SUMPRODUCT.

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

--
Biff
Microsoft Excel MVP


"Susan" wrote in message
...
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



On Jan 17, 3:05 pm, "T. Valko" wrote:
See this:

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

--
Biff
Microsoft Excel MVP

"Susan" wrote in message

...



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- Hide quoted text -

- Show quoted text -