Countif for Seperate Column

[jp16]

Lets say I am using Column A,C,E and G which contain number. Column B,D n F contain number too. I wan count how many cells is bigger than 1000 in A, C E and G.
I know i can use Countif(A:A,">"&1000)+Countif(C:C,">"&1000)+Countif(E:E,">"&1000)+Countif(G:G,">"&1000)

HOwever, is there anyway to just use one Countif formula ??

[PaulM100]

Use a countifs formula:

=countifs(A:A,">"&1000,c:c,">"&1000,e:e,">"&1000,g:g,">"&1000)

[jp16]

Not possible to have a Range like A:A;C;C;E;E;G;G,">"&1000?

[63falcondude]

No, but you can use something like this:

=SUMPRODUCT((A2:G100>1000)*(MOD(COLUMN(A2:G100),2)=1))

[tim201110]

=sum(mmult(--(a1:g20>1000),--transpose(isodd(column(a:g))))) cse