cell not calculating correctly
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need formula to be just the numberI can't seem to get the formula to go away and just be the answer. I have tried copying and pasting with special values, but that also did not work. I am new to Excel and do not fully understand it. https://preview.redd.it/nqjt1a1g5qxg1.png?width=826&format=png&auto=webp&s=5a7942502925fdfc3f189d62218a71622349e5c8 https://preview.redd.it/xht99d7i5qxg1.png?width=680&format=png&auto=webp&s=e6c363ce08480fcdaa6c96ae3f7d834ae9a2b8e2 submitted by /u/graveyard-bones [link] [comments]
- Formula works in most of the cells ant not othersI downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue submitted by /u/cbeard0245 [link] [comments]