Forum Discussion
Formula help
I am trying to write a formula to search my sheet for a particular name and when that name is found, I would like to average a particular column values. There are multiple names on this sheet, but I ...
=AVERAGEIFS($D$3:$D$28,$C$3:$C$28,C3)Does this return the expected result?
No, I am wanting to write a formula to come up with the number in the cells marked 'average for Amy', 'average for Bob' and 'average for Cathy'.
