LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Dynamic Calculation


I don't know if there is a non-programming way of doing this in the
Excel, if there is I would definitely prefer that. I need help
otherwise too..Here is what I am trying to do...

I have a cell which shows a value that is a summation of few other cell
values(let's say 1,2,3,...,10). I want to do dynamic summation in a way
that it calculates let's say only those cells which are before cell 4.
So basically, in the foirst month I will have the sum of the values of
only that month. Than in the second i will have the sum of the values
of both the months and so on.

So, basically I wanna show the calculation of values from 1st month to
whatever month we are in right now.

hopefully, somebody will be able to help me..

Thanks,


--
hem3414
------------------------------------------------------------------------
hem3414's Profile: http://www.excelforum.com/member.php...o&userid=29827
View this thread: http://www.excelforum.com/showthread...hreadid=495312

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic calculation of months remaining given end date and today Cruz_Control Excel Discussion (Misc queries) 2 April 30th 07 04:30 PM
dynamic IRR calculation Matt Excel Discussion (Misc queries) 0 October 13th 06 05:28 PM
Dynamic Field Selection - Calculation Matt Cromer Excel Discussion (Misc queries) 1 August 21st 06 11:13 PM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"