CountIF

Paul Molloy

Hi all

this formual does not seem to work and cant figure out why? I am looking to find how many projects in the "Install progress" column and not complete and expected to completed before 01/01/2021.

=COUNTIF([Install progress]:[Install progress], >"Complete": [Expected Comp Date]:[Expected Comp Date], < "01/01/2021")

thanks ;)

Jenna Bailey

try:

=countifs([Install Progress]:[Install Progress], "Complete",[Expected Comp Date]:[Expected Comp Date], < DATE(2021,01,01)

Jenna Bailey

try:

=countifs([Install Progress]:[Install Progress], "Complete",[Expected Comp Date]:[Expected Comp Date], < DATE(2021,01,01)

Paul Molloy

Thanks Jenna 😁