Good afternoon Chris Confused

You could use an array formula.

Highlight the range on your master sheet where you expect the values of
the formuale to go. Press "=" and then highlight your range on your
first source sheet (which must be the same size), press "+" and
highlight the range on your second source sheet, and so on. When your
formula is complete press ctrl + shift + enter to commit it.

It's a bit tricky to describe well, but try it - I think it will do
what you want and it's quicker than doing it cell by cell.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386746