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