Forum Discussion

CatherineMadden's avatar
CatherineMadden
Brass Contributor
Sep 24, 2022

Formula Help

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 ...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 24, 2022

CatherineMadden 

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.