Hi Rob

Thanks for this you are a star

broro183 Wrote:
Hi Paul,
I had another look & using the same assumptions as before except for
the need for a hidden row, the following will work;

=SUM(OFFSET($A$5,0,0,1,MATCH($A$1,$A$3:$L$3,0)))

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=503228