having a outside value referance a selection list

  • Thread starter Thread starter assws
  • Start date Start date
A

assws

Good Morning,

I have the following equation in my excel sheet.

=(SUMPRODUCT(D$4:D$20,$B$4:$B$20))/(SUM($B$4:$B$20))

What happens is that the data I am using increases by a row a day s
tomorrow the equation will be

=(SUMPRODUCT(D$4:D$21,$B$4:$B$21))/(SUM($B$4:$B$21))

Is there a way that I can put a number in a different cell
20 for today and 21 for tomorrow and have this value get plugged int
this equation automaticaly so I do not have to go and change th
formula every day?

Thanks
 
You could create a dynamic range with:

=SUMPRODUCT(OFFSET(B4,,,COUNT(B4:B65536)),OFFSET(D4,,,COUNT
(D4:D65536)))/SUMPRODUCT(OFFSET(B4,,,COUNT(B4:B65536)))


HTH
Jason
Atlanta, GA
 
Back
Top