Forum Discussion

lordtazzington's avatar
lordtazzington
Copper Contributor
Oct 01, 2024

Formula Help

Hi, I hope this is a thing and someone knows the way.

Is is possible, using the info in the Green sections, to have the Blue section automatically fill in the total based on values added manually in the Orange section? Spider for example: 2=8, 6=18, 1=1 and the check marks combined = 6, then add it all up and put the final value in the Blue section. Thanks 🙂

excel
Formulas and Functions
  • Martin_Angosto's avatar
    Martin_Angosto
    Iron Contributor
    Oct 01, 2024

    lordtazzington 

     

    Please see the attached document with proposed solution. You may change some references to fixed numbers in case you don't have information separated in a single cell.

     

    You should be in the right direction with this!

     

    Martin

Resources