Countifs not working with greater than (>1)

Hi guys

I have been scratching my head on this one for an hour, i have a range (Sheet1!$B2:$B99999) that has 1 to 10 in i have written a sum(countifs to count all the ones in the range (matching all other criteria ) and this is working fine (formula below)

=SUM(COUNTIFS(Sheet1!$B2:$B99999,"1",Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$12),COUNTIFS(Sheet1!$B2:$B99999,"1",Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$14))

however when i try and add a grater than 1 to count the remaining 2 to 10. it returns nothing

=SUM(COUNTIFS(Sheet1!$B$2:$B$99999,">1",Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$12),COUNTIFS(Sheet1!$B$2:$B$99999,">1",Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$14))

Please help i dont want to have to do a massive sum with 10 countifs

You could also utilize some reverse logic...

If the cells only contain values of 1 through 10
And you already have a formula that counts the 1's
Then logic says the remaining cells therefor must be 2 to 10 (greater than 1)

So say A1 contains your formula that counts the 1's.
Then to get the >1 you simply need to count ALL of them (regarldess if 1 or 2 or 3 etc..) and subtract A1.

=SUM(COUNTIFS(Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$12),COUNTIFS(Sheet1!$C$2:$C$99999,Sheet2!C24,Sheet1!$F$2:$F$99999,Sheet2!$A$1,Sheet1!$J$2:$J$99999,Sheet2!$A$14))-A1

It's OK I went to go for coffee and logic hit me me like a slap in the face

Thanks for replying to a stupid question tho. I just got stuck on a one way path I guess.

Would still be intrested to know why it didn't work tho I have already tried "<>1" that just returned the total.

Will tidy the formula up tomorrow good job it was only a proof of concept