Count across other files
I have 12 spreadsheets for gym membership, one for each month and each one contains a table showing whether a member is active or not in that month. Example below for September.
Member IDActive1Y2N3Y4N
5
N6N
The next month, October the table might look like this:
Member IDActive1N2N3Y4Y
5
Y6N
That would mean that MemberID 1,3,4 and 5 would have been active, ie a count of 4.
What’s the best way of creating a count for “The number of members active in the last 6 months”? So in October I would need to find this count using data from the Oct, Sep, Aug, Jul, Jun and May files.
Thanks
I have 12 spreadsheets for gym membership, one for each month and each one contains a table showing whether a member is active or not in that month. Example below for September. Member IDActive1Y2N3Y4N5N6N The next month, October the table might look like this: Member IDActive1N2N3Y4Y5Y6N That would mean that MemberID 1,3,4 and 5 would have been active, ie a count of 4. What’s the best way of creating a count for “The number of members active in the last 6 months”? So in October I would need to find this count using data from the Oct, Sep, Aug, Jul, Jun and May files. Thanks Read More
