need some formula help please
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
|