|Subject:||FORMULA HELP any body|
|Posted by:||deepak bsg|
|Date:||Thu, 23 Aug 2007|
I have the data with sales volumes of each customerwise for a financial
year. I have designed a format that is having three excel sheets. In
"sheet1", i have created a button and in that all months (i.e., apr-2007,
may-2007, like wise upto mar-2008)
In "sheet3" having all customerwise and monthwise data.
Now what i require is if i select the month in the "sheet1" from the button,
the cummulative of the total months starting from (ex: if i select july-07,
it has to pick up the apr-07-jul-07 cumulative volumes). My data in "sheet1"
is like this
c.code c.name apr-07 may-07 june-07.........mar-08 total
1010 xxxxxx 10 20 10 15
HOPE U HAVE UNDERSTAND IT.
All ready i used "SUMPRODUCT" for c.code, but i'm not able to get
cummulative volume as i have mentioned above.
CAN ANY BODY HELP ME ?