Averageif statement for Excel 2003

[chitownsox14]

Hi, I am looking to make an averageif function in excel 2003 that would average only the numbers that meet my criteria, but I cant figure out how to do it. I made an example table that I attached. Basically i want a function that will average the numbers (column B) only if they match the criteria (column A). Please help! Thank you in advance!Example.xls

[martindwilson]

do you mean
=SUMIF($A$2:$A$15,"A",$B$2:$B$15)/COUNTIF($A$2:$A$15,"A")

[Marcol]

Or an array formula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter not just Enter

[martindwilson]

oh no not another array lol basic maths rule sum/count cant be more straight forward than that!

[Marcol]

I thought that would get your back up Martin ...

Actually I was putting together a workbook with both when I noticed that the thread was marked [SOLVED]

Here it is
Note the headers

[martindwilson]

nice one marcol!