Thanks for that. Looks like I headed down the right lines while waiting (can't stop trying can you?)
I did forget that the Hol can be 2 types, Statutory or Compulsory Hol(s) or Hol(c). My fault.
I've been tinkering and came up with this, based on the contents of the column headings DUTY and WTD(located over alternate columns) and the value of the Constants sheet (Duty or WTD), depending on which I'm summing.:
Hol(s) 8.00 9.75 9.00 Hol(c) 0.00 10.00 9.25 9.00 8.25
=SUMIF(B2:M2,Constants!F2,B3:M3)
It seems to work too, which has surprised me most
Thanks again, at least I know I was using the right formula.
Bookmarks