I am trying to total the number of items that meet two conditions. I have tried to use sumproduct, but I seem to be doing something wrong.
Column A is the month:
I want to total the number of times a certain column is marked with a 1 for each month. I know this should be easy, but I can't seem to figure it out.