cell not calculating correctly
what i am trying to accomplish, and i have written and used this formula many times, but not recently, i dont have an old sheet to copy it from, i cant figure out why its not calculating correctily. i need H3 or I3 to show a total percentage, with final value of 1 or 100% of all the rows in F3. i've tried the formula in differt configs, tweaked, adjusted and just can t get it. see pic below for formula im using in H column. i set it up in a few columns so i can test/prove different versions at the same time.
i know its something minor i am missing. just need one box, H3 to display total percentage of column F. the formula in I3 works but stops calculating after a certain point, H3 and J3 are both just a mess.
any suggestions? working in excel desktop
[link] [comments]
Want to read more?
Check out the full article on the original site