thanks Mark, but Im still a bit confused - i have a horrendously long formula
thats got ifs/ors/ands/counts in it - when do i put the $ sign in, while
writing out the formula? Then how do i go about changing the worksheet
number?

Carol

"Mark Brown" wrote:

Carol,

If you put a "$" directly before the column reference in the formula (for
example, $F32), the column reference will not change. Likewise, a $ before
the row reference makes it not alter.

I'm not sure about your other question, sorry.

Mark

"englishrose4719" wrote:

How do I copy a formula along 31 columns in a summary spreadsheet without it
altering the column references? Because the data is coming from identical
spreadsheets but on different days of the month i need only the sheet number
to change.

Also is there a quick way to copy and paste the first formulated spreadsheet
across to the 30 others in one hit? Ive tried a couple of ways already
suggested but didnt get very far.

Thanks lots
Carol