SumIF Q

[Seanie]

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

Thanks

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Bernard Liengme]

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

 

[Seanie]

Thanks Peo, thats so easy