I am trying to create a counter in Excel.....
Lets say I have 5 groups of 5 cells in each group.
anytime a cell in group one is clicked I want a separate cell to keep a total count for that group..... then anytime a cell is clicked in group two.... I want there to be a total for group two.....but also......if I am clicking in group 2, I want all other totals to return to zero and so on...so if will only be counting the current group that is being clicked.....
is someone able to help me with this project...
I need detailed response please.