Using SUMPRODUCT with criteria

[sharky12345]

I'm using this formula to count the number of rows where the date falls in a specific month;

=SUMPRODUCT(1*(MONTH(BPBACKUP!B2:B5000)=7))

I need to take it a step further - I now need to count only those in the month of July, (as above), but only if the corresponding value in column C is 'Not Available'.

Anyone?

 

[arthurbr]

Try =SUMPRODUCT((BPBACKUP!C2:c5000="Not Available)*(MONTH(BPBACKUP!B2:B5000)=7))

 

[sharky12345]

Perfect - thanks!!