That's great for catching all of the 'typical' entries, but not for the 'late' entries (indicated by the "P#" at the end).... I changed the COUNTIF to SUMIF as I need to sum the hours from any past pay periods (ie. has the "P21" on the end") with the current pay period hours, but it's not finding them (P21 entreis) that way - if I use the COUNTIF as is, it counts the number of cells with "P21" but shows it across all columns - I need to tell it to only look for the code in row 3 (like the 1st part of the formula), but only pull the number if it has "P21" on the end....like the dynamic option for that also! - TIA