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