CountIF / IsDate combination
Comments
-
Try something along the lines of
=COUNTIFS([Date Column]:[Date Column], ISDATE(@cell))
If that doesn't work, could you provide your current formulas and a little more detail?
thinkspi.com
0 -
I realize this thread is a couple years old but I can't seem to get my COUNTIFS/ISDATE formula to work.
Current formula:
=IFERROR(COUNTIFS(OR(Date1:Date1, ISDATE([email protected]), Date2:Date2, ISDATE([email protected]), Date3:Date3, ISDATE([email protected]), Date4:Date4, ISDATE([email protected]), Date5:Date5, ISDATE([email protected]), Date6:Date6, ISDATE([email protected]), Date7:Date7, ISDATE([email protected]))), "")
I'm getting the #incorrect argument message. What do I have wrong?
Thanks, Peggy
0 -
@Peggy Parchert Are you able to describe exactly what you are wanting to accomplish and what your various column names are?
thinkspi.com
0 -
I want to know the count of how many of my date columns (Date1-Date7) have dates in them.
In the above example, it should show 6 in the Count column but I can't make it work.
Count is a text/number column
Date columns (Date1-Date7) is restricted to Date columns.
Thanks for the assistance.
Peggy
0 -
Try this:
=COUNTIFS([Date1]:[Date7], @cell <> "")
thinkspi.com
0 -
That gives me the count of the whole range but not by line. I probably should have said that above.
0 -
=COUNTIFS([Date1]@row:[Date7]@row, @cell <> "")
thinkspi.com
1 -
0
-
Happy to help. 👍️
thinkspi.com
0