sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,422
- Office Version
- 2016
- Platform
- Windows
I'm using this formula to count the number of rows where the date falls in a specific month;
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?
=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?