SOLVED

# Sum from drop down list?

Copper Contributor

# Sum from drop down list?

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.

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

# Re: Sum from drop down list?

For example like this:

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)

# Re: Sum from drop down list?

@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

# Re: Sum from drop down list?

For example like this:

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)