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" <amylina@gmail.com> wrote in message
news:1144338363.960216.93530@j33g2000cwa.googlegroups.com...
>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)