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...
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))