need some formula help please
hi bob:
that seems to work perfectly, thanks.
--
Gary
"Bob Phillips" wrote in message
...
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
|