Oct 10 2022 01:37 AM
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")
Oct 10 2022 01:47 AM
Solution=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".
Oct 10 2022 01:47 AM
Solution=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".