cumulative

A

afdmello

I entering daily consumption of raw materials in a series of cells daily and
printing it out on a daily basis(sheet1). I have created a identical summary
sheet which I need to add up the the values that I enter in sheet1 as a
cumulative total.

Thank you

Afd
 
B

Bernard Liengme

=SUM(Sheet!A1:A100) will sum all the cells in the range A1:A100 on the sheet
called Sheet1
If the sheet name has spaces you need single quotes
=SUM("Monday Data'!A1:A100)
best wishes
 

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

Help please!!! writing excel formula..... 6
need some basic help 4
Help with a formula please 2
PUZZLED - Daily Percentage Change and Cumulative 7
Custom Reporting Across Sheets 1
Excel Excel SUM function always returns a zero issue. 1
How to generate list of items with same status over three or moresuccessive days 2
Need help with date-time 3

Top