Countif every second row between Rows B and AP Excel 2010

[harleysrun]

Goodmorning, PLEASE HELP
I need to count every second row ie 48,50,52,54 etc between columm B and AP, values above 1300. Placing the absolute $ only in front of B and AP does not work. Can anyone help?
=COUNTIF($B48:$AP48,">1300")
TIA
Dan

 

[Takae]

=IF(MOD(ROW(),2)=1,"",COUNTIF($B48:$AP48,">1300"))
Put in each row.
(e.g column A)
A48 =result
A49=""(Blank)

OR, total
=SUMPRODUCT(($B$48:$AP$100>=1000)*(MOD(ROW($B$48:$AP$100),2)=0))

Hope this helps.

 

[harleysrun]

Thanks for your reply, is there any way in my function:
=COUNTIF($B48:$AP48,">1300")
I can get columns B - AP to be absolute $
And the row 48 to move 2 rows at a time when copied as in:
=COUNTIF($B48:$AP48,">1300")
=COUNTIF($B50:$AP50,">1300")
=COUNTIF($B52:$AP52,">1300")

Cheers