stop changing my formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paulnohio - 14 Aug 2006 15:11 GMT

Hi all: I am creating a report/graph combo. here is my issue. I am
summarizing a list of data and using that summary to create the charts.
I would like to insert daily a line to this table but have it only
calculate the last thirty days. As I add a line EXCEL adjusts the
formula for me, which is not what I want. I want the table to continue
to build for historical purposes, but to only calculate the last thirty
days. The cell calculation I want to be non adjusting is
"=SUM(B13:B13)". From other source I have read "=SUM($B$13:$B$13)"
should have done the trick but it does not. How do I tell EXCEL no to
adjust this calculation??

Thanks

Paul

Signature

paulnohio

Reply to this Message

Dave Peterson - 14 Aug 2006 18:09 GMT

=sum(indirect("b13:b13"))

But I have no idea how B13 corresponds to 30 days.

maybe
=sum(indirect("b13:b42"))

if you really meant just a single cell, you don't need =sum().

=$b$13
or in your case:
=indirect("B13")
would be sufficient.

> Hi all: I am creating a report/graph combo. here is my issue. I am
> summarizing a list of data and using that summary to create the charts.
[quoted text clipped - 16 lines]
> paulnohio's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37479
> View this thread: http://www.excelforum.com/showthread.php?threadid=571391

Signature

Dave Peterson

Reply to this Message