Forum Discussion
Use a conditional value in a formula?
I need to create a formula to get the average of 11 discontiguous cells. If there's a negative value in one of those cells, though, it should be dropped. Is this possible? Can it be done without...
=AVERAGE(FILTER(TOCOL(A2:E13,1),TOCOL(A2:E13,1)>0))
With Office 365 or Excel for the web this formula works in my example.
Thanks so much! I'll try that right away.