SOLVED

Adding date criteria to COUNTIFS

Copper Contributor

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")

2 Replies
best response confirmed by Davo_1988 (Copper Contributor)
Solution

@Davo_1988 

=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".

countifs.JPGpredicts.JPG 

Worked perfectly, thank you :)
1 best response

Accepted Solutions
best response confirmed by Davo_1988 (Copper Contributor)
Solution

@Davo_1988 

=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".

countifs.JPGpredicts.JPG 

View solution in original post