SUMPRODUCT excel ignore div/0

  • Thread starter Thread starter daniel.j.morton
  • Start date Start date
D

daniel.j.morton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DIV/0 6
Testing under Office 07 and getting #DIV/0! and #VALUE! 1
catching "#DIV/0!" in a loop 4
#DIV/0! criteria 9
Deleting rows when cell has "#DIV/0!" error 2
handling #Div/0! errors 3
Looping through HTML table to populate Excel 6
How to ignore #DIV/0! in Sumproduct formula 7

Back
Top