You could use something like

=SUMPRODUCT(--(rng1="value1"),--(rng2="value2"),rng2)<100

This will check the first range for a value, and a second range for a
second value, summing the second range, and CFing when that value < 100
--

HTH

RP
(remove nothere from the email address if mailing direct)


"andrewo-s" wrote in message
...
how to set up SUMIF conditional formula - based on 2 separate criteria -
over
hte same range and sum_range ?