how can I simultaneously divide each corresponding cells of two columns and sum all the results by ignoring blank cells.
Please find the screenshot.
B12=SUMPRODUCT(1/A9:A11,B9:B11)
B19=SUMPRODUCT(NOT(ISBLANK(A16:A18)),1/A16:A18,B16:B18) - not the expected result
Thanks in Advance.
Please find the screenshot.
B12=SUMPRODUCT(1/A9:A11,B9:B11)
B19=SUMPRODUCT(NOT(ISBLANK(A16:A18)),1/A16:A18,B16:B18) - not the expected result
Thanks in Advance.