I am trying to set up my google sheet to automatically adjust hours in the top section in the column "Used" when I input data into the details section. for example: In details section, when I add my benefit from a drop down list and input the hours used, I would like it to be linked to the top section part where it understands which benefit was used and automatically accumulate the hours used in the "Used" column. I would like it to do this everytime an entry is added to which ever benefit is applied.

enter image description here


1 Answer 1


Use sumif() like this in cell D4:

=sumif(B$12:B, B4, C$12:C)

  • Thankyou It worked just the way I wanted it to!
    – JDL
    Dec 9, 2021 at 22:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.