Auto populate text and add total from one sheet to another

Mary - Nov 9, 2017 at 11:30 AM
Hello,

I am trying to work on a yearly spreadsheet that has tabs for each month.
What we are trying to do is each month we update monthly tabs with names and no. of times person toileted and have another sheet auto populate the names and counts the totals of being toileted within 6 months.

EXAMPLE (Sheet 1 for July):
Name Toileted
BOB 1
Amy 0

EXAMPLE (Sheet 2 for August):
Name Toileted
BOB 2
Amy 1
In next months Bob and Amy were not toileted.

For Sheet that auto populates must update itself with BOB 3 and Amy 1 (total of Toileted added from past 6 months)

Will appreciate the help a lot!

See more