Forum Discussion
Countif multiple criteria and between dates
I am having some issues with a formula to count multiple criteria and if today falls between dates in two separate columns. The current one I have that works is. =countif(Services!$P:$P,”Honda”,Ser...
Hi Lee,
It could be like
=COUNTIFS(Services!$P:$P,”Honda”,Services!$Z:$Z, "Civic", Services!$S:$S,"<"&TODAY(),Services!$U:$U,">"&TODAY())
