Hi Stephanie

I don't fully understand your question.
=AVERAGEIFS(H15:H350,B15:B350, "=01/01/07", B15:B350, "<=01/31/07")
returns a correct value for me.

=COUNTIFS($C$15:$G$350, J1, $B$15:$B$350, "=01/01/07", $B$15:$B$350,
"<=01/31/07")
has an extra term that is superfluous, ,J1,

=COUNTIFS($C$15:$G$350, $B$15:$B$350, "=01/01/07", $B$15:$B$350,
"<=01/31/07")
works just fine.
--
Regards

Roger Govier


"Stephanie" wrote in message
...
I am trying to get the average of a multiple cell range. The criteria
range
and sum range are not the same size. Does countifs work the same way
regarding this?
Here is the formula I am trying to rearrange to work.
=AVERAGEIFS(H15:H350,B15:B350, "=01/01/07", B15:B350, "<=01/31/07").
This
one does not give me a true average because I am averaging an average.
=COUNTIFS($C$15:$G$350, J1, $B$15:$B$350, "=01/01/07", $B$15:$B$350,
"<=01/31/07"). I am trying to count a number in the c - g range using
a date
criteria.
Can you help?