I need help in drafting a formula in excel.
Problem statement.... in a row there are several numeric values....(aproxx 2000 values). there is a value in a cell....in want a formula in another cell such that the cell should keep on summing the values in that row untill the value of sum as compared to the value in cell is slightly greater than or equal to the value in cell. the formula should return the count of cells where value has been attained.
I hope I'm clear.
40 freelanceria on tarjonnut keskimäärin 1138 ₹ tähän työhön
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.