Mar 29 2021 07:10 PM
Hi
I have calculation wherein 0.31111is the cumulative of A/B. Assuming that I have only access to data in the row below B and I do not have access to data in row A and B,, how do I develop the Excel function to arrive to 0.31111.
Jan | Feb | March | Total | ||
A | 3 | 5 | 6 | 14 | 0.311111 |
B | 20 | 10 | 15 | 45 | |
0.15 | 0.5 | 0.4 | |||
Mar 29 2021 08:16 PM
Mar 29 2021 11:19 PM
It's simple just drag the formula in cell B4 till E4, and you get the expected value 0.311111, check the attached sheet!!
Mar 29 2021 11:38 PM
Mar 30 2021 12:06 AM
Mar 30 2021 12:13 AM
Mar 30 2021 05:31 AM