Hi
Cant seem to find quite what I am looking for, basically
I have a workbook with between 10 and 20 worksheets. I would like to
copy the same range c12:L42 (no of hours) on each sheet and paste to a
summary sheet. Some of the cells in the ranges may be blank (no
entry), I would like the summary to be pasted into the same range in
the summary sheet and add each entry as follows

If cell c12 has 5 on one sheet and 7 on another and no entry on each
of the other sheets the value in the summary sheet c12 would be 12.

I hope this is an understandable summary of my problem.

Many thanks as usual
Eddie