average if?

[day92]

Is there a way to average by category for a particular month? In the spreasheet attached I would like to average the following

New OB
New GYN
RTN (Return/Sick Visit)

By the month they occurred which is in row 2 highlighted in yellow. The grey columns give me the number of days which is what I want to average.

[Cutter]

In C34 put this?

=AVERAGEIF($A$3:$A$32,$A34,C3:C32)

Is that what you want?

Or, on second read, is this it?

=SUMPRODUCT(($A$3:$A$32=$A34)*(MONTH(B$3:B$32)=MONTH(B$2))*(C3:C32))/SUMPRODUCT(($A$3:$A$32=$A34)*(MONTH(B$3:B$32)=MONTH(B$2)))

or this array formula

=AVERAGE(IF((A3:A32=A34)*(MONTH(B3:B32)=MONTH(B2)),(C3:C32)))

[day92]

Cutter - yes that is exactly what I was looking for. thanks for your assistance. I could not figure that out for the life of me.