SOLVED

Sum from drop down list?

Copper Contributor

Hello!

I'm looking for some help with drop down lists and the SUMIF function that I can't seem to make work.

 

As in the screenshot below, the Networks (ie Sun) are from a selectable list. What I want to happen is that when someone adds an entry to the expense list, this amount is automatically deducted from the selected Network's budget so we can see how much money they have left remaining to spend. 

I've tried using SUMIF (which returns zero results) and the method contained here, but I don't think this would be live for subsequent entries.

Thanks in advance for your help, it's greatly appreciated!!

 

Screenshot 2024-03-14 132124.png

2 Replies
best response confirmed by kipjack1792 (Copper Contributor)
Solution

@kipjack1792 

For example like this:

HansVogelaar_0-1710757895209.png

Column H contains the unique networks, column I their budgets, and column J the remaining amounts.

The formula in J2 is

=I2-SUMIF(A2:$A$1000, H2, $D$2:$D$1000)

@HansVogelaar OMG you are a lifesaver, thank you so much!! This has been on my list at work for ages and now I can finally cross it off, with everyone thinking how Excel-smart I am. Thank you so so much again for solving this problem, I am so very appreciative!!!

1 best response

Accepted Solutions
best response confirmed by kipjack1792 (Copper Contributor)
Solution

@kipjack1792 

For example like this:

HansVogelaar_0-1710757895209.png

Column H contains the unique networks, column I their budgets, and column J the remaining amounts.

The formula in J2 is

=I2-SUMIF(A2:$A$1000, H2, $D$2:$D$1000)

View solution in original post