CODEWITHSUNDEEP
excel
Daniel64
Daniel64

Reputation: 29

How can I find a condtional average in Excel based off a column's value?

I have data with Four columns: Name (A), Sex (B), Year Born (C), Income (D).

What formula could I use to find the average income of all people born in 1995?

This is what I'm trying now: =MEDIAN(IF(C:C = 1995, D:D))

But it's not working. Any ideas why?

Upvotes: 1

Views: 25

Answers (1)

Ethilium
Ethilium

Reputation: 1234

=AVERAGEIF(C1:C4, "=1995", D1:D4)

Office Support Article

See this similar SO question for more information.

Upvotes: 1

Related Questions