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((510)*(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

SUMPRODUCT excel ignore div/0
 

=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


wrote in message
oups.com...
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((510)*(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