View Single Post
  #3   Report Post  
Don Guillett
 
Posts: n/a
Default

try
=sumproduct((rnga="x")*(rngb=1)*rngc)

--
Don Guillett
SalesAid Software

"Holly B." <Holly wrote in message
...
I would like to sum a range if column A = x and column B = y then sum

those
numbers in range C that meet the criteria. Is this possible? SumIf only
allows for one range and criteria, how can I get around this?