To gather the data of the cell $P$31 from the worksheets in a single total
sheet I would do the following:
- Write the numbers from 1 to 301 in column A
- Write this formula in column B: = A1 & "!$P$31"
- Rewrite the if formula to use indirect: =IF(D1=0,0,INDIRECT(B1))

You know better what layout works for you, but I hope this helps.

Miguel.

"copying formula of multiple worksheets" wrote:

Heres my formula =IF(B2=0,0,'1'!$P$31) 1 is worksheet 1, I have 310
worksheets and a total sheet, How can I copy this formula down to show
worksheet 2 then 3? thanks alot