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$1:$B$15=D2)*($C$1:$C$15=D3)) | ||||||
| JOANA | IP | 12-Jan-21 | |||||||||
| Trizia | BL | 12-Mar-21 | |||||||||
| Lee | BL | 13-Feb-21 | |||||||||
| Pauly | SOA | 09-Feb-21 | |||||||||
| Pauly | C220 | 10-Jan-21 | |||||||||
| JOANA | RP | 12-Mar-21 | |||||||||
| Lee | BL | 15-Jan-21 | |||||||||
| Lee | RP | 12-Jan-21 | |||||||||
| JOANA | BL | 09-Feb-21 | |||||||||
| Myke | BL | 29-Jan-21 | |||||||||
| Trizia | NP | 29-Jan-21 | |||||||||
| Myke | NP | 12-Jan-21 |
8 Replies
- 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.
- 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.
In general for such counting it's better to use PivotTable
If formula
=SUMPRODUCT( ($A$2:$A$16 = D2) * ($B$2:$B$16 = D3) * ( MONTH($C$2:$C$16) = MONTH(D4) ) )here
