In excel, I am looking to calculate the sum of reciprocals for each number in the column, starting from that number.
Below works fine:
Ex: Below formula for each of the cell in second column
7hZww.pngPlease Login or Register to view this content.
But if I have a column with no value then it wont as the it treats nulls as zero and gets a divide by zero error.
HVG2H.png
If I use =SUMIF(1/J2:J6, ">0") then it's not working.
Any help to achieve this please?
Bookmarks