=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