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 could use

 

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

  • AlexEanbu's avatar
    AlexEanbu
    Copper Contributor
    Sep 18, 2023
    thank you so much, it works 🙂

Resources