Hi,
=SUMIF($C$5:$C$39,"Y",N$5:N$39)/(COUNTIF($C$5:$C$39,"Y")-COUNTBLANK(N$5:N$39))
In Col C, there are dropdowns for choosing Y or N. In Col N I only want to see the average of the numbers which say "Y" in Col. C. But the formula I have here counts all blank cells in Col. N including those don't say "Y" in Col. C.
Please help.
Bookmarks