I got some help yesterday with an average issue.
I'm attempting to average specific cells not in a range while ignoring div/o
errors.
This is what I'm using:
=AVERAGE(if(ISERROR(AC4,AC40,AC85,AC94,AC121,AC139 ,AC175,AC202,AC220,AC247,AC274),"",(AC4,AC40,AC85, AC94,AC121,AC139,AC175,AC202,AC220,AC247,AC274))(A C4,AC40,AC85,AC94,AC121,AC139,AC175,AC202,AC220,AC 247,AC274))
I can't make it work. What's wrong with it?
Thanks,
Tammie