Forum Discussion
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.
Thanks in advance for your help, it's greatly appreciated!!
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)
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)
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!!!
