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”,Services!$Z:$Z”Civic)
What I want to add is a countif function that counts those if today falls in-between column $S:$S is early dates, and Column $U:$U overdue date. An idea of what i am trying for
=countif(Services!$P:$P,”Honda”,Services!$Z:$Z”Civic,Services!today>$S:$S,today<$U:$U)
My computer internet’s is out at the moment when it comes up I’ll try and upload a file
=countif(Services!$P:$P,”Honda”,Services!$Z:$Z”Civic)
What I want to add is a countif function that counts those if today falls in-between column $S:$S is early dates, and Column $U:$U overdue date. An idea of what i am trying for
=countif(Services!$P:$P,”Honda”,Services!$Z:$Z”Civic,Services!today>$S:$S,today<$U:$U)
My computer internet’s is out at the moment when it comes up I’ll try and upload a file
Hi Lee,
It could be like
=COUNTIFS(Services!$P:$P,”Honda”,Services!$Z:$Z, "Civic", Services!$S:$S,"<"&TODAY(),Services!$U:$U,">"&TODAY())
