Setting up "Progressive" Formulas between worksheets/files

L

Loathario

Please bare with me as I try to explain what it is I am trying to do, if you
understand my intention you'll understand how you're asving me HOURS, so for
that, Thanks !

I have 2 workbooks, lets call them addons2 and addons3 :) I am trying to
input data in to one workbook and have formulas calculate averages. Another
quick explanation: I am calculating sales for my employees in 4 catagories
over 12 months by the week. 66x52x4 is how many formulas I would have to
individually create which is why I am seeking your help :) I'll give you the
first formula and explain what I am trying to do:

=SUM((([addon2.xls]Dec!$B$2*[addon2.xls]Dec!$C$2)+([addon2.xls]Dec!$G$2*[addon2.xls]Dec!$H$2)+([addon2.xls]Dec!$L$2*[addon2.xls]Dec!$M$2)+([addon2.xls]Dec!$Q$2*[addon2.xls]Dec!$R$2)+([addon2.xls]Dec!$V$2*[addon2.xls]Dec!$W$2))/[addon2.xls]Dec!$AA$2)

I am multiplying the number of sales by the amount, summing the weeks by
months, then getting the average based off of the total # of sales. Now I can
change every single $Letter$Number to match but again, 12k times isn't my
idea of fun so I ask how can I make all the 2's become 3's on the line below,
then 4's, then 5's and so on.

Thanks for any help !!

P.S. If there is a command to make $letter$row# that would work if it made
row# the current row the formula was on ... if that's possible.
 
O

OssieMac

If I understand you problem correctly, just delete the $ sign in from the 2's
.. Change this:-
Dec!$B$2 to this Dec!$B2

That way the column is absolute but not the row.
 
D

David Biddulph

And get rid of the SUM function from the formula. You aren't actually using
it, I believe.
--
David Biddulph

OssieMac said:
If I understand you problem correctly, just delete the $ sign in from the
2's
. Change this:-
Dec!$B$2 to this Dec!$B2

That way the column is absolute but not the row.
--
Regards,

OssieMac


Loathario said:
Please bare with me as I try to explain what it is I am trying to do, if
you
understand my intention you'll understand how you're asving me HOURS, so
for
that, Thanks !

I have 2 workbooks, lets call them addons2 and addons3 :) I am trying to
input data in to one workbook and have formulas calculate averages.
Another
quick explanation: I am calculating sales for my employees in 4
catagories
over 12 months by the week. 66x52x4 is how many formulas I would have to
individually create which is why I am seeking your help :) I'll give you
the
first formula and explain what I am trying to do:

=SUM((([addon2.xls]Dec!$B$2*[addon2.xls]Dec!$C$2)+([addon2.xls]Dec!$G$2*[addon2.xls]Dec!$H$2)+([addon2.xls]Dec!$L$2*[addon2.xls]Dec!$M$2)+([addon2.xls]Dec!$Q$2*[addon2.xls]Dec!$R$2)+([addon2.xls]Dec!$V$2*[addon2.xls]Dec!$W$2))/[addon2.xls]Dec!$AA$2)

I am multiplying the number of sales by the amount, summing the weeks by
months, then getting the average based off of the total # of sales. Now I
can
change every single $Letter$Number to match but again, 12k times isn't my
idea of fun so I ask how can I make all the 2's become 3's on the line
below,
then 4's, then 5's and so on.

Thanks for any help !!

P.S. If there is a command to make $letter$row# that would work if it
made
row# the current row the formula was on ... if that's possible.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top