rsboulevard
New Member
- Joined
- Oct 22, 2020
- Messages
- 18
- Office Version
- 2010
- Platform
- Windows
I am trying to count the # of dates that are older than today along with other criteria in other columns. I am getting a value! error. The first formula returns an accurate count, but when I mix in the the date count criteria, I receive the error message. SecondDose is a named range of cells that only contain short date type dates, no blank cells.
=SUM(COUNTIFS(Employees!G11:G9958,"Fully Vaccinated",Employees!D11:D9958,"Active",Employees!J11:J9958,{"Pfizer-BioNTech","Moderna"}))
=SUM(COUNTIFS(Employees!G11:G9958,"Fully Vaccinated",Employees!D11:D9958,"Active",Employees!J11:J9958,{"Pfizer-BioNTech","Moderna"},SecondDose,">="&TODAY()))
=SUM(COUNTIFS(Employees!G11:G9958,"Fully Vaccinated",Employees!D11:D9958,"Active",Employees!J11:J9958,{"Pfizer-BioNTech","Moderna"}))
=SUM(COUNTIFS(Employees!G11:G9958,"Fully Vaccinated",Employees!D11:D9958,"Active",Employees!J11:J9958,{"Pfizer-BioNTech","Moderna"},SecondDose,">="&TODAY()))