Forum Discussion
Solved
Countifs a selected month is between date range
Hi all I may be getting confused with this one, but essentially I have the following table: I am trying to use COUNTIFS to count how many projects from the table are between the date range (...
Perhaps
=CHOOSECOLS(FILTER(A2:C1000, (B2:B1000<=AA3)*(C2:C1000>=AA3)), 1, 3)
Hi HansVogelaar
Thank you for the quick response.
If I was to use this in a FILTER formula as follows, how would it be incorporated?
=FILTER(FILTER($A:$C,COUNTIFS($B2:$B6, "<="&$AA$3, $C2:$C6, ">="&$AA$3)),{1,0,1}))
Perhaps
=CHOOSECOLS(FILTER(A2:C1000, (B2:B1000<=AA3)*(C2:C1000>=AA3)), 1, 3)