Forum Discussion

AlexEanbu's avatar
AlexEanbu
Copper Contributor
Sep 18, 2023
Solved

Average

  fx= Average of Product from jan to apr?        Which Means sum of each month of DVD and their Average?
excel
  • HansVogelaar's avatar
    HansVogelaar
    Sep 18, 2023

    AlexEanbu 

    You could use

     

    =SUMPRODUCT($C$2:$F$19*($B$2:$B$19=H2))/COUNTA($C$1:$F$1)

HansVogelaar's avatar
HansVogelaar
MVP
Sep 18, 2023

AlexEanbu 

You changed the screenshot since I composed my reply. My reply was based on the original screenshot.

 

In H2:

 

=AVERAGE(IF($A$2:$A$18=G2, $B$2:$E$18))

AlexEanbu's avatar
AlexEanbu
Copper Contributor
Sep 18, 2023
I Dont know , how could it work?
not working bro
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 18, 2023

    AlexEanbu 

    If you do not have Excel 2021 or Excel in Micorosft365, confirm the formula by pressing Ctrl+Shift+Enter.

     

    If that doesn't work: Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources