using sumif to sum a range of values
 

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

using sumif to sum a range of values
 

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

using sumif to sum a range of values
 

=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

using sumif to sum a range of values
 

Fantastic, thanks
--
hwy


"JE McGimpsey" wrote:

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

using sumif to sum a range of values
 

Great, thank you very much.

--
hwy


"Duke Carey" wrote:

=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