countif - "incorrect argument"

Joerg Schmidt

Hi,

=COUNTIF(ISDATE([nächste Wartung]1:[nächste Wartung]51); <=TODAY()))

doesn´t work - why?

Paul Newcome

It should NOT matter.

Paul Newcome

Try something like this...

=COUNTIFS([nächste Wartung]1:[nächste Wartung]51, AND(ISDATE(@cell), @cell <= TODAY()))

Joerg Schmidt

I got

"Invalid Data Type" ?

Paul Newcome

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.

Joerg Schmidt

Yes,

[nächste Wartung] is set to date type and

we have semicolons.

Hope you find the point ;-)

Paul Newcome

How is the date generated in that column?

Joerg Schmidt

=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))

Paul Newcome

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...

Joerg Schmidt

I am sorry. it still shows = #Invalid Data Type

Paul Newcome

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.

Joerg Schmidt

still #Invalid.

Last question. Does it matter that the formula is in the sheet summary and not in a cell inside the sheet ?

Paul Newcome

It should NOT matter.