Related Posts
“We had complimenting genitalia.”
Additional Posts in Excel Genius
Anyone know what these badges are?

Still don't have xlookup. #fomo
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.






Why don’t you just do a pivot table? That way you can slice and dice your data however you’d like.
Pivot table here would be a better option
^this. Quick tutorial on pivot table will change your life.
The hard way is to code with IF or SUMIF
haha yes, I no longer use these formula in these scenarios
Coach
First things first, separate those new tables in a different part of the sheet (or in another sheet). You can then create new columns to pull the information from those tables, using =INDEX(FILTER()) and a # column (1,2,3...) to control the index for different names
Second, a pivot table here not only doesn't solve the issue but is also a very bad recommendation, practical and performance-wise.