Formula to calculate amount of games played

3D formula to count across sheets.
N3:N11, P3:P11, R3:R11, T3:T11

Please Login or Register  to view this content.

1. $A$2:$J$2 are the column headers but also the tab names. Ensure that the names in the cells and the tab names do not have leading or trailing spaces, they must match exactly.
2. You should be using the same layout for all weekly sheets with no merged cells.

Originally Posted by protonLeah

3D formula to count across sheets.
N3:N11, P3:P11, R3:R11, T3:T11

Please Login or Register  to view this content.

1. $A$2:$J$2 are the column headers but also the tab names. Ensure that the names in the cells and the tab names do not have leading or trailing spaces, they must match exactly.
2. You should be using the same layout for all weekly sheets with no merged cells.

Thank you for looking into this for me.

I can see that all the games that have been played are not matching up.

The formula needs to capture the amount of "entries" that the person has played, I should of been clearer.

Thank you,
Brad2018

Dropdown list in Q2 chooses the week Number.
Replacement formula for sum of entries to the choosen week (cols N, P, R & T)

Please Login or Register  to view this content.

@ Brad, please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.