Forum Discussion

Orlanie Lagrimas's avatar
Orlanie Lagrimas
Copper Contributor
Nov 04, 2018

What to do

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.

 

excel

6 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 05, 2018

    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

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Nov 05, 2018

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

    • Orlanie Lagrimas's avatar
      Orlanie Lagrimas
      Copper Contributor
      Nov 05, 2018

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

Resources