Thank you for this info. I think I am going to sick with the original logic you helped me with ... just 1 accrual at a time.

If I use =IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"") is it possible for it to look at additional cells in a different row? Something like =IF(COUNTIF(J7:N7,B9:H9,"VAC")>0,COUNTIF(J7:N7,B9:H9,"VAC")*8,"")

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">=IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"")</body>****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">=IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"")=IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"")=IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"")=IF(COUNTIF(J7:N7,"VAC")>0,COUNTIF(J7:N7,"VAC")*8,"")</body>