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 ...
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!!!
