View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

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.