Thanks for the reply,
also possible is
=SUMIF(A1:J1,"<Hol*")
to cover both types.
Cheers
HappyTrucker Wrote:
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.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=395644