Forum Discussion

a7024782's avatar
a7024782
Brass Contributor
May 23, 2022
Solved

Contar con Sumaproducto y 4 filtros

Saludos: tengo la siguiente formula =SUMAPRODUCTO(--((AP!$Y$8:$Y$2999)=$C$31);--((AP!$AQ$8:$AQ$2999)=$B36);--(AP!$AT$8:$AT$2999=C$3)), con ella obtengo un resultado que es la cuenta de determinados v...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    May 23, 2022

    a7024782 

    =SUMPRODUCT(N((AP!$Y$8:$Y$2999)=$C$31),N((AP!$AQ$8:$AQ$2999)=$B36),N(AP!$AT$8:$AT$2999=C$3),N(MONTH(AP!$B$8:$B$2999)=MONTH(D$32)))

    I've entered this formula in an empty sheet and it returns the expected result of 2992.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 23, 2022

a7024782 

=SUMPRODUCT(N((AP!$Y$8:$Y$2999)=$C$31),N((AP!$AQ$8:$AQ$2999)=$B36),N(AP!$AT$8:$AT$2999=C$3),N(MONTH(AP!$B$8:$B$2999)=MONTH(D$32)))

I've entered this formula in an empty sheet and it returns the expected result of 2992.

Resources