Conditional Average Ignoring Blanks

[Dirk Friedrichs via OfficeKB.com]

Help, I'm stumped!

I need a formula solution to do the following:

Average the currency total in column Y, only if column F = "smith", and
ignore any/all blank cells in column Y.

Any help would be greatly appreciated!!

Dirk

 

[Peo Sjoblom]

=AVERAGE(IF((F2:F200="F")*(Y2:Y200<>""),Y2:Y200))

entered with ctrl + shift & enter

 

[Dirk Friedrichs via OfficeKB.com]

Brilliant! Thanks so much for your help - works perfectly!