How do I set up a cumulative column, without entering it manually

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up a cumulative column in excel and I'm having to enter it
manually. Is there a way to do this quickly without having to do it manually.
 
Assume your data is in Column A.
In B1, enter: =A1
In B2, enter: =B1+A2
Fill down as far as you need

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
Pivot Tables.

HTH,
Bernie
MS Excel MVP


LG said:
I am setting up a cumulative column in excel and I'm having to enter it
manually. Is there a way to do this quickly without having to do it
Click to expand...
manually.
 
You must log in or register to reply here.

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

Similar Threads

How do I perform extended calculations in a Pivot Table in Excel 2 4
Countif or sumif for cumulative sums,pivot table & chart 2
monthly cumulative worksheets 2
Access YTD - Form 0
cumulative total 1
Windows 10 Microsoft rolls out second cumulative update for Windows 10 3
Excel Excel SUM function always returns a zero issue. 1
SUMIF Cumulative share 2

Back
Top