Forum Discussion
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...
D3 is custom formatted as mmm-yy, intended for the whole month. What I would like to get is the total of all BL, C220 etc. for the month. Further info column D3 is a list made in data validation. Thank you.