Lets say we have 5 sheets in a workbook.
3 columns per sheet.
Column A lists "Names".
Column B lists "*" that represents whether a name is a member (only certain names have these).
Column C lists "Points".
Need a "Summary" sheet that looks at those 5 sheets, finds the "names" in column A that have a "*" in column B and totals all the "points" in column C.
Example:
"Bob" is a member & has 3 points on each of the 5 sheets, so ideally the summary sheet would list "Bob" in column A & the total of "15" in column B.
Is it possible?
Bookmarks