Hello all I am trying to do a countifs with the formula below and its not working I am not sure what I am doing wrong.


=COUNTIFs(Data!F:K,CI4,Q:Q,">0",S:S,"Yes")I think the issue is the range F:F through K:K but I am not sure how to put it?

Any help please!