Dave,

Andy's formula worked OK when I tried it. I couldn't come up with any ideas
why he might be getting the result he's getting.

As for commas and asterisks, usually, when we use SUMPRODUCT in this way,
we're not using the "product" part of the function. When we separate the
boolean expressions with asterisks, we're multiplying them, so there's only
one argument to the SUMPRODUCT, hence no commas.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Dave O" wrote in message
ups.com...
The arguments for SUMPRODUCT() are separated by commas, rather than
stars. The first one resulted in an error because the proper arguments
are not present. My guess is the second works because there were
*enough* arguments to return an answer: Excel evaluated the A=Toys *
B=Date as the first argument and column C as the second argument.