Conditional Average Ignoring Blanks

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

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

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Dirk Friedrichs via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
message news:1155c8ed7fe043dcbd1c72dd5e0b0c98@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

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