copying absolute references

how can I copy the following formula down without having
to change each indiviual sheet reference. I've tried using
indirect in the formula, but I'm not having any luck. I
have researched various sites and I can't seem to find
anything that will make sense to me.

=IF($A$10"",SUMIF('Base Bid Item (1) '!
$B$11:$B$110,"L.10*",'Base Bid Item (1) '!G$11:G$110)-
SUMIF('Base Bid Item (1) '!$B$11:$B$110,"=M.11*",'Base
Bid Item (1) '!G$11:G$110),"")

Can any one help?

If you want the absolute reference to be relative, edit out the "$" signs appropriately.

"Dave W" wrote:

how can I copy the following formula down without having
to change each indiviual sheet reference. I've tried using
indirect in the formula, but I'm not having any luck. I
have researched various sites and I can't seem to find
anything that will make sense to me.

=IF($A$10"",SUMIF('Base Bid Item (1) '!
$B$11:$B$110,"L.10*",'Base Bid Item (1) '!G$11:G$110)-
SUMIF('Base Bid Item (1) '!$B$11:$B$110,"=M.11*",'Base
Bid Item (1) '!G$11:G$110),"")

Can any one help?

Hi
how should your sheet names change?. Is there a naming logic for them?.
e.g. if they are named like
'Base Bid Item (#number)

then try the following formula
=IF($A$10"",SUMIF(INDIRECT("'Base Bid Item (" & ROW(1:1) & ") '!
$B$11:$B$110"),"L.10*",INDIRECT("'Base Bid Item (" & ROW(1:1) & ")
'!G$11:G$110"))-
SUMIF(INDIRECT("Item (" & ROW(1:1) & ")
'!$B$11:$B$110"),"=M.11*",INDIRECT("'Base
Bid Item (" & ROW(1:1) & ") '!G$11:G$110")),"")


--
Regards
Frank Kabel
Frankfurt, Germany


Dave W wrote:
how can I copy the following formula down without having
to change each indiviual sheet reference. I've tried using
indirect in the formula, but I'm not having any luck. I
have researched various sites and I can't seem to find
anything that will make sense to me.

=IF($A$10"",SUMIF('Base Bid Item (1) '!
$B$11:$B$110,"L.10*",'Base Bid Item (1) '!G$11:G$110)-
SUMIF('Base Bid Item (1) '!$B$11:$B$110,"=M.11*",'Base
Bid Item (1) '!G$11:G$110),"")

Can any one help?

Thank you Frank
You assumed correctly regarding the sheet naming
I have been pulling my hair out trying to get
the "indirect" approach to work.

-----Original Message-----
Hi
how should your sheet names change?. Is there a naming
logic for them?.
e.g. if they are named like
'Base Bid Item (#number)

then try the following formula
=IF($A$10"",SUMIF(INDIRECT("'Base Bid Item (" & ROW
(1:1) & ") '!
$B$11:$B$110"),"L.10*",INDIRECT("'Base Bid Item (" & ROW
(1:1) & ")
'!G$11:G$110"))-
SUMIF(INDIRECT("Item (" & ROW(1:1) & ")
'!$B$11:$B$110"),"=M.11*",INDIRECT("'Base
Bid Item (" & ROW(1:1) & ") '!G$11:G$110")),"")


--
Regards
Frank Kabel
Frankfurt, Germany


Dave W wrote:
how can I copy the following formula down without
having
to change each indiviual sheet reference. I've tried
using
indirect in the formula, but I'm not having any luck. I
have researched various sites and I can't seem to find
anything that will make sense to me.

=IF($A$10"",SUMIF('Base Bid Item (1) '!
$B$11:$B$110,"L.10*",'Base Bid Item (1) '!G$11:G$110)-
SUMIF('Base Bid Item (1) '!$B$11:$B$110,"=M.11*",'Base
Bid Item (1) '!G$11:G$110),"")

Can any one help?

.