Countifs not working

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.

Please Login or Register  to view this content.

=COUNTIFs(Data!F:K,CI4,Q:Q,">0",S:S,"Yes")

Please Login or Register  to view this content.

I think the issue is the range F:F through K:K but I am not sure how to put it?

Any help please!

All the ranges in countifs must be equally dimensioned.
You can't have 1 range that is 6 columns, bu thte others are only 1 column.

Try
=SUMPRODUCT(--(((Data!F$1:F$1000=CI4)+(Data!G$1:G$1000=CI4)+(Data!H$1:H$1000=CI4)+(Data!I$1:I$1000=CI4)+(Data!J$1:J$1000=CI4)+(Data!K$1:K$1000=CI4))>0),--(Data!Q$1:Q$1000>0),--(S$1:S$1000="Yes"))

Thank you I tried it but I get a "REF" I guess it is the range . I am going to have to do just do a helper column then. Thank you for your help though.

You're welcome.

And by the way, Helper columns are NOT a bad thing....
That's why they're called 'Helper', because they Help.

This is true I just wanted to have a more cleaner version but I do appreciate the help

Ok I am trying to post it now