Hi - I need to add the same cell (F9) in three worksheets. I can't get the syntax right - I keep trying sum(worksheet1:worksheet3) but it doesn't work. I don't want to point to the cell in each sheet because if I add new sheets I want to make sure the summary page adds the new inserted worksheet. Does anyone know the correct syntax.
Thanks!
Thanks!