What to do

Orlanie Lagrimas
New Contributor

Hi, Guys,


Need your help. 


What will be my formula for the table below.  I know its looks easy but I have a hard time manipulating the formula here.


My goal is to get the average of the test result for the entire week.



6 Replies

pls find attached file.

hope that this can help you.


Hi Orlanie,


Does Lorenzo's response solve the problem?


I understand that you need to get the weekly scores average for each Test number.

But, is the data in Sheet 1 for all weeks?

How the weeks is categorized?


If you attached the workbook, that would be better.



Mr. Amairah

nice of you to pitch-in.


Wow you're amazing Lorenzo.  I got the file and its exactly I want to achieve.  Superb

Yes.  Lorenzo made it possible.  Thanks

Glad that it helped.
Mr. Amairah has some valid points - you might want to clear it up with him.
He is very helpful.


btw - the column on TEST# should be sorted to make it work...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies