cumulative

  • Thread starter Thread starter afdmello
  • Start date Start date
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
 
=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
 
Back
Top