Thread
:
How do I sum a range after 2 different conditions are met (2 colu.
View Single Post
#
3
Don Guillett
Posts: n/a
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?
Reply With Quote