Tom, Thanks again for replying,

I have no idea how to build such a formula the formula on my count up
sheet is this
=COUNTIF(Hols1,E2)*8+COUNTIF(Hols2,E2)*12+COUNTIF( Hols3,E2)*8+F2
(although it does vary from cell to cell as it looks for names on
another sheet but it still looks for the named ranges) E2 shown here is
the name it is looking for in the named range (formula stored in G2) so
in the next cell down it will look at E3 etc. its when i sort a row in
to the named ranges that it no longer counts properly i.e instead of
counting in multiples of 8 it may count in 12's or vice versa!

Any ideas?

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=504473