lynx20
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I get an error when I enter. It highlite the 0 in the formula.
Bob
Bob
could you upload a sample?
ASKER
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
Test.xls
You've missed a ")"
Should be =SUM(IF(ISERROR(1/BC5:BJ5) ,0,1/BC5:B J5))
Should be =SUM(IF(ISERROR(1/BC5:BJ5)
ASKER
Thanks. I guess I've been staring at this thing for too many days.
No problem, I know the feeling, I assure you!
Cheers for the grade!
Darren
Cheers for the grade!
Darren
This is an array formula, so enter with Ctrl + Shift + Enter
HTH
Darren