Hi,

I am trying to count how many integer values I have in "col3"

COUNTIFS(data[col1], "=1", data[col2],"="&A7,data[col3],"").

I know how to do that with standard if - IF(J12=INT(J12),"A","B")

In this standard IF I have J12 cell to work with, but with COUNTIFS I don't have reference to specific value in the array (Maybe there is a way?).