Hi Gary,

Try

=SUM(IF(MOD(ROW(H$5:H$28),2)=0,IF(NOT(ISERROR(H$5: H$28)),$H$5:$H$28),0))

This is an array formula, so commit with CTrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
and there were semicolons instead of commas. i changed them but still get
n/a for the result

--


Gary


"abcd" wrote in message
...
sorry, translation error,
it's

SUMPRODUCT

and not sumprod