im just looking at attempt one... the way you have your formula set up is get the pivot data for AWOL and if theres an error get the pivot data from SICK..etc etc until you get to the end where you have the beginning of an if statement stating "IF pivotdata to look at" with 0 logical statement and 0 true or false answers for the logical statement... Does my formula in my above post work? its hard to see if it works on my end because i dont have access to this workbook.