Forum Discussion
Solved
Adding date criteria to COUNTIFS
Hello.
I'm trying to add a criteria to an existing COUNTIFS formula so that it will only return values if todays date is greater than a date in a cell.
Existing formula is below
=COUNTIFS(Predicts!$E:$E,V3,Predicts!$A:$A,$V$4,Predicts!$F:$F,"Yes")
=COUNTIFS(Predicts!$E:$E,V3,Predicts!$A:$A,$V$4,Predicts!$F:$F,"Yes",Predicts!$G:$G,"<"&TODAY())You can try this formula if the date is in column G in sheet "Predicts".
2 Replies
=COUNTIFS(Predicts!$E:$E,V3,Predicts!$A:$A,$V$4,Predicts!$F:$F,"Yes",Predicts!$G:$G,"<"&TODAY())You can try this formula if the date is in column G in sheet "Predicts".
- Worked perfectly, thank you 🙂
