I'm working on a counifs formula that seeks to look at values within a date range and then also check if a table column meets a criteria. Here is the first part of the formula for date range:
=COUNTIFS(Daily!A:A, ">="&Weekly!A3, Daily!A:A, "<="&Weekly!B3) - where Weekly!A3 and Weekly!B3 are specific date values. So far so good. The formula spits out the number of values within the date range.
The problem occurs when I try to add a third IF statement to check the number of times "y" shows up in a table column. If I check ONLY for this condition with the formula: =COUNTIFS(TableName[ColumnName], "y") - it works perfectly.
HOWEVER, when I combine the 2 into: =COUNTIFS(Daily!A:A, ">="&Weekly!A3, Daily!A:A, "<="&Weekly!B3, TableName[ColumnName], "y") - the formula does not work and I get the error #VALUE! Any ideas how to fix this and the logic behind it? Thanks in advance.
=COUNTIFS(Daily!A:A, ">="&Weekly!A3, Daily!A:A, "<="&Weekly!B3) - where Weekly!A3 and Weekly!B3 are specific date values. So far so good. The formula spits out the number of values within the date range.
The problem occurs when I try to add a third IF statement to check the number of times "y" shows up in a table column. If I check ONLY for this condition with the formula: =COUNTIFS(TableName[ColumnName], "y") - it works perfectly.
HOWEVER, when I combine the 2 into: =COUNTIFS(Daily!A:A, ">="&Weekly!A3, Daily!A:A, "<="&Weekly!B3, TableName[ColumnName], "y") - the formula does not work and I get the error #VALUE! Any ideas how to fix this and the logic behind it? Thanks in advance.