SUMPRODUCT excel ignore div/0

Hello,

I have searched through the groups and found suggestions as to how to
include "if" statements to capture div/0 and exclude them. The problem
I am having is how to exclude from the range all values equal Div/O. I
read that an error is propogated in a formula. I found
=SUMPRODUCT((5>10)*(5/0)) shows Div/O. I can use an If to capture the
2nd argument but not if the 2nd argument is a range of cells C1:C50
which may have div/0 at cell C5, C13, C16. Any suggestions how I can
get sumproduct to ignore these values? thanks.

Daniel

=SUM(IF(ISERROR(C1:C10),0,C1:C10),A1:A10)
entered as an array formula (enter with ctrl+shift+enter rather than just
enter) will work.

--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I have searched through the groups and found suggestions as to how to
> include "if" statements to capture div/0 and exclude them. The problem
> I am having is how to exclude from the range all values equal Div/O. I
> read that an error is propogated in a formula. I found
> =SUMPRODUCT((5>10)*(5/0)) shows Div/O. I can use an If to capture the
> 2nd argument but not if the 2nd argument is a range of cells C1:C50
> which may have div/0 at cell C5, C13, C16. Any suggestions how I can
> get sumproduct to ignore these values? thanks.
>
> Daniel
>