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" wrote in
message ...
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!