Need help with Countifs

Sean Maney

Wrote this formula but its not working:

=COUNTIFS(Stage:Stage, "Active - Low. Probability", [R2 Offer Submitted Date]:[R2 Offer Submitted Date], >=[Bid Due Date]:[Bid Due Date])

Kleerfyre

Try using [Bid Due Date]@row instead of the whole column.

Eric Law

@Sean Maney

Could you us a helper column that does that logic for you.

Helper =IF([R2 Offer Submitted Date]@row >=[Bid Due Date]@row, "Yes", "No")

Then you can use =COUNTIFS(Stage:Stage, "Active - Low. Probability", Helper:Helper, "Yes")

Sean Maney

The helper column worked, thanks.

R2 Submitted Date > BDD is the helper column: =IF([R2 Offer Submitted Date]@row > [Bid Due Date]@row, "Yes", "No")

This is working: =COUNTIFS(Stage:Stage, "Active - High Probability", [R2 Submitted Date > BDD]:[R2 Submitted Date > BDD], "Yes")

Now I need to add to the COUNTIFS if the [R2 Submitted Date] is blank and TODAY is >[Bid Due Date]

Thanks for your help

Sean Maney

Why doesn't this work?

=COUNTIFS(Stage:Stage, "Active - High Probability", [R2 Submitted Date]@row, > [Bid Due Date]@row)

Eric Law

@Sean Maney That doesn't work because you [R2 Submitted Date]@row is not a range, you need to change it to [R2 Submitted Date]:[R2 Submitted Date].