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 only want to average the set belonging to that person. I believe it is an IF, THEN formula, but I'm not sure how to average the values. Thank you!
4 Replies
No the above won't work for me. What I'm trying to do is to find a formula that will give me the following:
I'm looking for an easy way to collect the average percentages for each person. My excel file has over 33,000 rows and I'm looking for an efficient way to calculate the average percentages for each person.
=IF(B3<>B4,AVERAGEIFS($C$3:C3,$B$3:B3,B3),"")You can enter this function in cell D3 and fill it down to row 33000.
=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'.
