It won't work with errors in this way, the H5:H28 will error out even though
the ISNA(H5:H28) will evaluate to False.

--

HTH

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


"abcd" wrote in message
...

check the excel help
or give us the exact new formula you'd tryed

the sumproduct function is supposed to work perfectly