Column A is a list of names (Jack, John, Sue), Column B is a date (dd/mm/yy format), Column C is a score.
ON a separate sheet I want to have a chart that would add all scores by each individual based on a month selected. Cell A1 on sheet 2 would have the month and year listed (mm/yy format). Cell A2-A4 would have the list of the names (Jack, John, Sue). Cells B2-B4 would have a summed total of all scores listed on sheet 1 for each individual, but only would sum the scores that the mm/yy matched cell A1 on sheet 2.
Bookmarks