Formula Help

D

deepak bsg

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)
 
P

Pete_UK

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
 
D

deepak bsg

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top