Running Total

This may seem a silly question but how do you get a running total to work form one Work Sheet to another from a daily list to a monthly list, this =DailyBirdList!$B$3 updates the monthly list but will not keep a running total, I have tried lots of way but it will not work.

 

 

AttachmentSize
DailyBirdList.xls25.5 KB

On a similar vein

I'm trying to accomplish almost the exact same thing, but have no VB skills. Is there any other way to accomplish the same task? (that is, taking daily input data and adding it to ongoing weekly, monthly, or annual totals?)

JPH's picture

Another way

You could insert new data in a new column and add a date to that column and use a pivottable to extract your info.