Excel 2007
Problem:
Trying to have a running count of a unique dynamic value in Sheet 1 (Summalry tab) B3. Look for that dynamic value in Sheet 2 (Data tab) where it occurs in multi-rows B3:Q25. The totals to sum are in the Q column.
In other words, find all 11111 in Sheet 2 and sum all totals from column AJ
Please see attached file...
Bookmarks