does AVERAGEIF work with text values?

Hello,

I have the following formula that calculates the average with numbers:
=AVERAGEIF('Individual Player Raw Data'!B:B,$B66,'Individual Player Raw Data'!G:G)

I would like to use the exact same format but for cells with text.
for example, lets say in my G:G column on the 'Individual Player Raw Data'! sheet, I have: apples; bananas; apples; pears; oranges.
I want the answer i get to be Apples.

Is this possible?

Thank you.

You can use text in the criteria, but not for the average range.

Hope this helps.

Pete

Originally Posted by Pete_UK

You can use text in the criteria, but not for the average range.

Hope this helps.

Pete

i dont understand.

i think i may have explained it terribly.
of course with text values i wont be using an average formula, maybe more like a mode formula (most common text value).

what can i do?

Originally Posted by Fotis1991

Try something like this.

=INDEX($g$3:$g$100,MODE(MATCH($g$3:$g$100,$g$3:$g$100,0)))

im sorry youve lost me.
if you could please incorporate your formula with the one i posted in the OP, id be able to understand it so much more.
i'll be using those exact cell references.

thank you.

I've done as requested. Please find attached my excel doc.


let me explain from scratch:

first i manually input all data on the 'individual player raw data' sheet.
so now i only need to input the date in column A on the 'Team Data' sheet to get all the data as a team.
Column E and F on the 'Team Data' sheet is already done. This AVERAGEIF formula calculates the score in each match.
Now i want the opposition column to automatically update too by calculating that under a certain date, we played a particular opposition so that will show up on column B on the 'Team Data' sheet.
Because its text and not a number, im not sure how to do this. I think a mode formula would work because it will calculate that its the most common (only) opposition under a particular date.

feel free to ask any questions.

thank you so much for your time and effort.

Originally Posted by Fotis1991

Have you more than 1 match per day?

no. only 1 opposition per date.

Originally Posted by chemistb

do you ever play more than 1 match a day? If not,
=index('individual player raw data'!$c$3:$c$250, match(a3, 'individual player raw data'!$b$3:$b$250,0))

it worked.
You geinus!!!

Thank you so much