Hello,
In a previous post I got a great answer on the calculation of an average with several conditions. However, I need now a combination of that formula with IF and INDIRECT function.I think it has to begin with: IF(ISTEXT($A7),AVERAGE(INDIRECT(A7&"!"&" , after this I don’t know how to combine the both. In the attachment there is an example
The average formula: =AVERAGE(INDEX(C2:C781,MATCH(1,N(B2:B781>=122),0)):C1048576)
Many thanks in advance.
Kind regards,
I.L
Bookmarks