countif - "incorrect argument"
Hi,
=COUNTIF(ISDATE([nächste Wartung]1:[nächste Wartung]51); <=TODAY()))
doesn´t work - why?
Best Answer
-
It should NOT matter.
Answers
-
Try something like this...
=COUNTIFS([nächste Wartung]1:[nächste Wartung]51, AND(ISDATE(@cell), @cell <= TODAY()))
-
I got
"Invalid Data Type" ?
-
Double check that your [nächste Wartung] column is set to a date type column. Also... I missed the fact that your region uses semicolons instead of commas, so you would need to also adjust that from my earlier formula.
-
Yes,
[nächste Wartung] is set to date type and
we have semicolons.
Hope you find the point ;-)
-
How is the date generated in that column?
-
=DATE(YEAR([letzte Wartung]@row) + ROUNDDOWN((MONTH([letzte Wartung]@row) + Wartungsintervall@row) / 12; 0) + IF(IF(MOD(MONTH([letzte Wartung]@row) + Wartungsintervall@row; 12) = 0; 12; MOD(MONTH([letzte Wartung]@row) + Wartungsintervall@row; 12)) = 12; -1); IF(MOD(MONTH([letzte Wartung]@row) + Wartungsintervall@row; 12) = 0; 12; MOD(MONTH([letzte Wartung]@row) + Wartungsintervall@row; 12)); DAY([letzte Wartung]@row))
-
That's what I was afraid of. So the data is an actual date as well. Do you have any blanks or non-date data within the range?
=COUNTIFS([nächste Wartung]1:[nächste Wartung]51, AND(ISDATE(@cell), IFERROR(@cell, TODAY(2)) <= TODAY()))
Lets try that...
-
I am sorry. it still shows = #Invalid Data Type
-
Ok. Let's try logging out, clearing your cache and cookies, then logging back in again. This formula SHOULD be working, so we are getting close to needing to reach out to Support. It may even be something as simple as the sheet just needs refreshed on the back-end.
-
still #Invalid.
Last question. Does it matter that the formula is in the sheet summary and not in a cell inside the sheet ?
-
It should NOT matter.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!