Forum Discussion

mrcuenco's avatar
mrcuenco
Copper Contributor
Jan 29, 2022

Help. How can I total the BL, IP, NP, etc. per month using sumproduct. Thank you.

Pauly NP 12-Feb-21 JOANA                 Trizia BL 18-Mar-21 IP 1  =SUMPRODUCT((A1:A15=D1)*(B1:B15=D2))     Myke BL 17-Mar-21 Jan-21 0  =SUMPRODUCT(($A$1:$A$15=D1)*($B...