Conditional Average Ignoring Blanks

  • Thread starter Dirk Friedrichs via OfficeKB.com
  • Start date
D

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
 
P

Peo Sjoblom

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

entered with ctrl + shift & enter
 
D

Dirk Friedrichs via OfficeKB.com

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