Multiple criteria in Data Validation

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

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Amy Stein" <[email protected]> wrote in message
news:[email protected]...
>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
>

you can use the following Way

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