Code
=AVERAGE(AVERAGEIF(Standards['[35S']GTPyS],[@Nominal],Standards[Rep1]),AVERAGEIF(Standards['[35S']GTPyS],[@Nominal],Standards[Rep2]),AVERAGEIF(Standards['[35S']GTPyS],[@Nominal],Standards[Rep3]))
I have three values I'd like to average based on the adjacent cell (@NOMINAL) in a table and it works if all the cells have values but if one of them is empty it returns #DIV/0. Is there a way I can have it average only the two values if the third is empty?
Thanks