Changing sheet in a simple formula when dragging it

[k.m.]

Is it possible to make Excel change the sheet when dragging a formula? The cell look like this:

=COUNTIF(Sheet1!E:E;"CC")+COUNTIF(Sheet1!G:G;"CC")

When I drag it down I'd like it to count the same value in the same rows in sheet2, sheet3 etc. Is that possible?
I'm not experienced with Excel at all, så maybe it's easy as hell, but I just cant find a solution (tried to search Excel help and google without luck, but didn't really know what to type in the search...)

There's quite a lot of columns with the same formula, just different values to be counted, so I'd hate to have to change the sheet manually every time I add a new sheet to the document...

[bebo021999]

If worksheets named as sheet1,2,3,...
try this:

Please Login or Register  to view this content.

Drag down to get the sheet# increasing.

[k.m.]

Nice, thanks for the fast reply, it works like a charm :-)