COUNTIFS formula to pull number of overdue tasks associated with owner

Abby Stanek · 05/21/24

I am trying to pull data for a Sheet Summary with this formula:

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], "<" & TODAY())

I am getting an unparseable error, it seems to be around the () next to TODAY.

What do I need to change to have my formula be correct?

bisaacs · 05/21/24

I just realized what the issue is! Remove all the brackets around your column ranges:

=COUNTIFS(Owner:Owner, "jane doe", Deadline:Deadline, <TODAY())

You only use brackets in ranges if the column name has a space in it, otherwise don't use them for one word column titles, like so:

=COUNTIFS([Owner Name]:[Owner Name], "Jane Doe", Deadline:Deadline, <TODAY())

bisaacs · 05/21/24

You shouldn't need the quotes around the <, it should just look like this:

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], <TODAY())

Hope this helps!

Abby Stanek · 05/21/24

I just switched it to the below formula and am still getting an unparseable error

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], <TODAY())

bisaacs · 05/21/24

I just realized what the issue is! Remove all the brackets around your column ranges:

=COUNTIFS(Owner:Owner, "jane doe", Deadline:Deadline, <TODAY())

You only use brackets in ranges if the column name has a space in it, otherwise don't use them for one word column titles, like so:

=COUNTIFS([Owner Name]:[Owner Name], "Jane Doe", Deadline:Deadline, <TODAY())

Abby Stanek · 05/21/24

This did it!

bisaacs · 05/21/24

NVM

Best Answer