Sep 24 2022 02:04 PM - edited Sep 24 2022 02:16 PM
Hello, attached is an example of the file I am needing a formula for.
I am looking for a formula that will add up the points for a week per person. I have to do this for each week for the next 4 months. I was trying a Xlookup combo since the names can change rows when they are filtered.
Sep 24 2022 03:17 PM
Sep 24 2022 03:46 PM - edited Sep 24 2022 04:05 PM
The way the September sheet is arranged makes it very difficult to analyze the data. Impossible? No, it can be done with some of the functions available to Insiders and those using Excel 365 (Current channel).
The easiest data arrangement to analyze is when data runs vertically with as few columns as possible. Merged cells should be avoided if at all possible. I've re-arranged the September sheet and created the SUMIFS and AVERAGEFIS.
Revamped September sheet:
Additionally, I found and removed 3500+ tiny pictures from this workbook:
I found them by going to Home | Find and Select | Selection Pane. I noticed the workbook was a bit sluggish to navigate. An abundance of objects makes Excel work harder to render them on screen even if they're tiny and practically invisible.