Multiple criteria in Data Validation

[Amy Stein]

I have a worksheet that uses data validation with a Sumif()
restriction. I want to add another Sumif() restriction on the same
range of cells. Is this possible?

Thanks in advance-
Amy

 

[Peo Sjoblom]

Use sumproduct, what's the conditions you want to validate for?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[krupesh]

you can use the following Way

Sum(if((1st condition)*(2nd Condition)),Sum range)