=sumproduct(--(b2:b1000="2006"),--(f2:f1000="proposed"),c2:c1000)


"highwayman" wrote:

Is there a way to use sumif to sum a range of values based on two conditions.
In other words I would like to sum a range of values in col c if values in
col b are equal to "2006" and values f are equal to "proposed".
Thanks

--
hwy