SumIF Q
 

How can I construct a formula that will ADD the cells B34:Q34 where
the corresponding cells in B35:Q35 = Expired

Thanks

SumIF Q
 

=SUMIF(B35:Q35,"Expired",B34:Q34)

--


Regards,


Peo Sjoblom

"Seanie" wrote in message
...
How can I construct a formula that will ADD the cells B34:Q34 where
the corresponding cells in B35:Q35 = Expired

Thanks

SumIF Q
 

=SUMIF(B35:Q35,"Expired", B34:Q34)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Seanie" wrote in message
...
How can I construct a formula that will ADD the cells B34:Q34 where
the corresponding cells in B35:Q35 = Expired

Thanks

SumIF Q
 

Thanks Peo, thats so easy