More Divide by Zero Problems

[diablo]

The answers to my previous post worked wonderful with the exception of this
specific formula.

my original code, works but gives divide by zero error when empty.
=SUMPRODUCT(B2:B65536,C2:C65536)/SUM(C2:C65536)

my code after I applied the logic that is working on other formulas, this
one always returns a blank cell regardless.
=IF(ISERROR((SUMPRODUCT(B2:B65536,C2:C65536)/SUMC2:C65536)),"",(SUMPRODUCT(B2:B65536,C2:C65536)/SUMC2:C65536))



Would anyone mind looking at the second line of code to see where I'm in
error?

It's much appreciated,
Brian

 

[Bob Phillips]

=IF(ISERROR(SUMPRODUCT(B2:B65536,C2:C65536)/SUM(C2:C65536)),"",SUMPRODUCT(B2
:B65536,C2:C65536)/SUM(C2:C65536))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[diablo]

Hi Bob,

I had tried that combination of parentheses and what I get in the cell is
#NAME?

I'm wondering if using a set of arrays with the ISERROR function will even
work.

Thanks,
Brian

--

 

[Bob Phillips]

Worked fine for me. It isn't BG wrap-around by any chance? Try this

=IF(ISERROR(SUMPRODUCT(B2:B65536,C2:C65536)/SUM(C2:C65536)),"",
SUMPRODUCT(B2:B65536,C2:C65536)/SUM(C2:C65536))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[diablo]

Bob, I don't know what the deal was. I took the line wrap off both times by
pasting into notepad first. The second time around it worked for me. Thanks
for looking at this you've helped me a bunch.

Thanks,
Brian

--