=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