TRUNC function in COUNTIF or COUNTIFS produce error message

[Solvap]

Hello,

Would you know why the usage of a TRUNC function into COUNTIF our COUNTIFS, as here-after, produce the following error message ?
=COUNTIF(TRUNC($A$2:$A$6),D$1)

The range $A$2:$A$6 contains some numbers with decimals and I aim to count how many of them matches the cell D1 that contains only integers. I did found a work-around (with the SUM...), but, still, I'm surprised as I don't see what is wrong with COUNTIF or COUNTIFS. Is it possible that function like COUNTIF can't handle arrays resulting from another function ?

This works =SUM(--(TRUNC($A$2:$A$6)=D$1))
This doesn't work =COUNTIF(TRUNC($A$2:$A$6),D$1)

Thank you in advance for your time.
Solvap

 

[Fluff]

All the xxif(s) functions only work on ranges & not arrays.

 

[Solvap]

Hello Fluff,

Thx for the info, I wasn't aware of that limitation.

Kind regards
Solvap

 

[Fluff]

You're welcome & thanks for the feedback.