AlexEanbuCopper ContributorSep 18, 2023SolvedAverage fx= Average of Product from jan to apr? Which Means sum of each month of DVD and their Average? Show MoreHansVogelaar to AlexEanbuSep 18, 2023AlexEanbu You could use =SUMPRODUCT($C$2:$F$19*($B$2:$B$19=H2))/COUNTA($C$1:$F$1)
HansVogelaar to AlexEanbuSep 18, 2023AlexEanbu You could use =SUMPRODUCT($C$2:$F$19*($B$2:$B$19=H2))/COUNTA($C$1:$F$1)
HansVogelaar to AlexEanbuSep 18, 2023AlexEanbu You could use =SUMPRODUCT($C$2:$F$19*($B$2:$B$19=H2))/COUNTA($C$1:$F$1)
HansVogelaarMVPSep 18, 2023AlexEanbu You could use =SUMPRODUCT($C$2:$F$19*($B$2:$B$19=H2))/COUNTA($C$1:$F$1)
