I would like to do an averageif on cells that are greater than 0, and not filled a certain color (some shade of pink in my scenario)
obviously I know how to take care of the first filter, but what about the second, how could I do this?
edit: If this is not possible I am open to any suggestions regarding changing the pink fill color distinction to something that would enable this type of calculation.
Bookmarks