The problem!I have totals to enter on a daily basis for input and output.How can I update running totals for the month.For instance :For May say - 31 daily entries - rows 1 to 31 - running total row 32. I need 32 to show monthly running total as I enter each daily total into 1 to 31.Thanks.
Inserting a simple sum formula in row 32 ie =sum(row1:row31) should be all you need the result of which will be zero until you start adding daily data.
Simple when you know how!Thanks!Now problem two!A similar request but I need to show a total again in row 32 but this time as data is entered in each of rows 1 to 31 I want it to minus from a carried forward figure.For instance X is carried forward from April. Entering data for rows 1 to 31 for May will show a total equal to [X minus daily amount = running total in row 32]Thanks again!
very similar to the first answer =sum(row1:row31)-X , where x = row with figure you need subtracting.Most of this is explained in Excel help or if you are going to be using it a lot take an online course.
Thanks for the advice and solutions.I don't have Excel on this machine and am emailing the solution to a third party.The problems are solved.Thanks again.
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.