# Is there a sum inverse function?

Hi All:

Is there a function that will sum the inverse of a range of cells, which also allows for zeros as some of the values?  The same as: 1/A1 + 1/B1 + ... +1/H1  and allow for a 0 value in B1 & E1.

Bob
LVL 9
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
=SUM(IF(ISERROR(1/A1:A10),0,1/A1:A10))

This is an array formula, so enter with Ctrl + Shift + Enter

HTH
Darren
Commented:
or more suitably...

=SUM(IF(ISERROR(1/A1:H1),0,1/A1:H1))

Entering as an array formula should insert the formula in {}

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
I get an error when I enter.  It highlite the 0 in the formula.

Bob
Commented:
Author Commented:
I cannot upload the entire workbook so I created a value only version of the sheet.  I am attempting to enter the formula in U5.
Test.xls
Commented:
You've missed a ")"

Should be   =SUM(IF(ISERROR(1/BC5:BJ5),0,1/BC5:BJ5))
Author Commented:
Thanks.  I guess I've been staring at this thing for too many days.
Commented:
No problem, I know the feeling, I assure you!