Hello,
I apologize ahead of time if this doesn't make sense at first.
I have a table that has the date as a header across a row, and sample names down a column.
(Sorry, I am unable to attach files currently).
example.jpg
I need to count the total number of samples taken during a certain month (disregarding any text). In the example table above, if I were trying to count the number of samples for January, it should be 14. For February it should be 16.
I can use
=COUNTIFS(B3:G12,"<>"&"",B3:G12,"<>N/A",B3:G12,"<>Down")
and that works to count ALL samples no matter the date.
However, I cannot figure out what to add or change in the function to count only for the specific months.
I've tried an IF statement
=IF(AND(B2:G2>"12/31/2015",B2:G2<"2/01/2016"),COUNTIFS(B12:G21,"<>"&"",B12:G21,"<>N/A",B12:G21,"<>Down"),0)
I've also added empty rows and tried
=SUM(COUNTIFS(B2:G11,">12/31/2015",B2:G11,"<2/01/2016",B12:G21,"<>"&"",B12:G21,"<>N/A",B12:G21,"<>Down"))
I just get 0 with both.
I feel like I am missing something simple... Any help would be appreciated.
Bookmarks