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)