Forum Discussion
Solved
Obtener el valor promedio de un rango pero solo de las celdas visibles
Saludos a todos: tengo esta formula: =SI.ERROR(PROMEDIO.SI.CONJUNTO(G8:G3000;$B8:$B3000;">="&$A6;$B$8:$B$3000;"<="&$B$6);0) que devuelve el valor promedio de un rango de acuerdo a un filtro de fechas...
If you're on 365, this might work for you:
=MAX(MAP(B8:B3000,G8:G3000,LAMBDA(b,g,IF(AND(b>=$A$6,b<=$B$6,SUBTOTAL(102,b)=1),g,0))))
If you're on 365, this might work for you:
=MAX(MAP(B8:B3000,G8:G3000,LAMBDA(b,g,IF(AND(b>=$A$6,b<=$B$6,SUBTOTAL(102,b)=1),g,0))))
Hi Patrick2788
It seems a7024782 was looking to compute an AVERAGE. Your LAMDBA is really nice but not sure it generates an AVG 😉