One way:

=SUMPRODUCT(--(B1:B100=2006),--(F1:F100="proposed"),C1:C100)

for an explanation of "--", see

http://www.mcgimpsey.com/excel/doubleneg.html


In article ,
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