Thread: Countif with other functions -- Median, IF, Count

I feel like I should know this, but I'm having a brain cramp.

I want to find the average of column B for the values that have "Y" in column D.


I'm also looking for this one:

For all values that have "Y in column D, how many of those have "N" in column Z.



Can someone point me in the right direction, thanks!

In Excel 2007 and later (and presumably Mac2008 and later?) you can use the AVERAGEIF (one criteria) and AVERAGEIFS (multiple criteria) function.

If those aren't available, you can use the array version like:

=AVERAGE(IF(D1:D100="Y",B1:B100))

confirmed with CTRL+SHIFT+ENTER, not just ENTER. (The AVERAGEIF/S do not need to be array entered.)

Hi

1.

Code:

=AVERAGEIF(D1:D100,"Y",C1:C100)

2.

Code:

=COUNTIFS(D1:D100,"Y",N1:N100,"N")

Rgds