FORMULA HELP any body

Giganews Newsgroups
Subject: FORMULA HELP any body
Posted by:  deepak bsg
Date: Thu, 23 Aug 2007

Hello Everybody
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
55

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 ?
THANKS INADVANCE

Replies