i have 2 formulas i would like to combine, unless somebody has a better
idea.

i want to sum every other row in a column
=SUM(IF(MOD(ROW(H$5:H$28),2)=0,H$5:H$28,0))
this will sum all even rows

but some may have n/a in them:
=SUM(IF(ISNA(H5:H28),0,H5:H28))
this will sum all rows that don't contain n/a

i am looking for a formula that will sum every other row, but skip n/a's.

any help appreciated


--


Gary