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.
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.