Forum Discussion
Count if with multiple criteria
I would like to create a formula to count values for a specific month, and count them if they are equal to the date in the column next to it. For example: Count if the date in column A is January and date is equal to the date in column B.
| Submission Date | Original Due Date |
| 1/15/2017 | 1/10/2017 |
| 10/15/2017 | 10/15/2017 |
| 11/15/2017 | 11/15/2017 |
| 12/15/2017 | |
| 2/15/2017 | 2/15/2017 |
| 3/15/2017 | 3/15/2017 |
| 4/15/2017 | 4/17/2017 |
| 5/15/2017 | 5/15/2017 |
| 6/15/2017 | 6/15/2017 |
| 7/15/2017 | 7/14/2017 |
| 8/15/2017 | 8/15/2017 |
| 9/15/2017 | 9/14/2017 |
| 2/5/2017 | 2/6/2017 |
| 3/5/2017 | 3/3/2017 |
| 4/5/2017 | 4/5/2017 |
| 5/5/2017 | 5/4/2017 |
| 6/5/2017 | 6/5/2017 |
| 7/5/2017 | 7/5/2017 |
| 8/5/2017 | 8/4/2017 |
| 9/5/2017 | 9/5/2017 |
1 Reply
Hi,
That could be like
=SUMPRODUCT((MONTH($A$1:$A$100)=1)*($A$1:$A$100=$B$1:$B$100)*($A$1:$A$100>1))
