Formula to Search and Average (Excel-Any)

Topic

New Reply

I need your help to think this formula through. I have names in column A and values in column B. I want to search column A for the names Sarah and Woody, and get the average of their associated values. Is there a quick way to do this? It’s Friday and my brain is fried….thanks!

Reply | Quote

Replies

=SUMIF(A:A,”Sarah”,B:/countif(A:A,”Sarah”)
=SUMIF(A:A,”Woody”,B:/countif(A:A,”Woody”)

Steve

Reply | Quote

Thanks, Steve! That jump-started my thought process. Now, what if I wanted to add all of the values I find and average both Sarah’s and Woody’s together?

I have this formula, but it’s taking the average of the averages.
=((SUMIF(A:A,”Sarah”,B:/COUNTIF(A:A,”Sarah”))+(SUMIF(A:A,”Woody”,B:/COUNTIF(A:A,”Woody”)))/2

Reply | Quote

=(SUMIF(A:A,”Sarah”,B:+SUMIF(A:A,”Woody”,B:)/(COUNTIF(A:A,”Sarah”)+COUNTIF(A:A,”Woody”))

Reply | Quote

Thanks, Chaunce. I can rest easy this weekend!

Reply | Quote