Hey Folks,
I'm struggling with the calculation of a dependent AVERAGE-Function.
Here is my case, as provided in the attachment:
I want to include only cells within the AVERAGE function where is no "X" underneath. When I return "" or 0 as false output from IF, AVERAGE treats that as value 0.
Any ideas how to solve this?
Best regards
idlebert
Bookmarks