Home

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.

 

Untitled.png

6 Replies

pls find attached file.

hope that this can help you.

thanks..

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.

 

Regards

Mr. Amairah

nice of you to pitch-in.

thanks..

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.
thanks..

 

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