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
|