Hello Every body.

I have data in a sheet1 month wise sales i.e.,

c.code C.name Apr-07 May-07 June-07 July-07.. likewise
Cummulative
1010 ABCD 10 20 30 40 200
1020 XYZA 5 15 20 15 150

I want cummulative result of Apr-07, May-07 and June-07, FUNCTION has to
pick up the
data of Apr-07, May-07 and June-07 and should give cummulative fig of every
customer.

eg: ABCD total sales 10+20+30=60 (Result)

Assuming you have 12 months of data occupying columns C to N so that
your cumulative total is in column O, enter this formula in O2 and
copy down:

=SUM(C2:N2)

Hope this helps.

Pete

On Jul 24, 12:20 pm, deepak bsg
wrote:
Hello Every body.

I have data in a sheet1 month wise sales i.e.,

c.code C.name Apr-07 May-07 June-07 July-07.. likewise
Cummulative
1010 ABCD 10 20 30 40 200
1020 XYZA 5 15 20 15 150

I want cummulative result of Apr-07, May-07 and June-07, FUNCTION has to
pick up the
data of Apr-07, May-07 and June-07 and should give cummulative fig of every
customer.

eg: ABCD total sales 10+20+30=60 (Result)

sorry pete
actually my criteria is i wrote link from page to page when i changed the
month (i.e., june 07 ) it has pick up upto the perticular months (apr-jun)
sales cummulatively. i got 658 customers. with different sales areas.
any help?

"Pete_UK" wrote:

Assuming you have 12 months of data occupying columns C to N so that
your cumulative total is in column O, enter this formula in O2 and
copy down:

=SUM(C2:N2)

Hope this helps.

Pete

On Jul 24, 12:20 pm, deepak bsg
wrote:
Hello Every body.

I have data in a sheet1 month wise sales i.e.,

c.code C.name Apr-07 May-07 June-07 July-07.. likewise
Cummulative
1010 ABCD 10 20 30 40 200
1020 XYZA 5 15 20 15 150

I want cummulative result of Apr-07, May-07 and June-07, FUNCTION has to
pick up the
data of Apr-07, May-07 and June-07 and should give cummulative fig of every
customer.

eg: ABCD total sales 10+20+30=60 (Result)