If/Then calculate the average
Luckily, others were wider awake than I was, and spotted the "," in
place of the "=" in your array formula.
--
Regards
Roger Govier
Roger Govier wrote
Hi Lynn
I can't see whay that array formula wouldn't work, unless there is
something wrong with the data.
You could try
=SUMPRODUCT(--(A2:A399="MUSIC"),--(I2:I339))/COUNTIF(A2:A339,"MUSIC")
|