Results 1 to 6 of 6

Thread: Numbers update automatically when certain values are selected

  1. #1

    Post Numbers update automatically when certain values are selected



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am working on a spreadsheet where if I select a type in L the number in K should automatically update in U. I used the formula =IF(L2:L90="HE 155",(K2:K90), 0). It updates correctly on the U2, however when I use the same formula for U3 and change the ="HE 155" to ="HE 105" the formula only works for u2, but not for u3.

    any suggestions are appreciated, I attached the spreadsheet for context.
    MISSIONS FIRED REPORT.xlsx

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    As you have them, it looks like your trying to work with array formulas but your not using them correctly. Are you trying to put a total shots number into Col U by adding up the matching L Codes in T?

    If so, try:
    =SUMIF($L$2:$L$90,$T2,$K$2:$K$90) In U2, copied down.

    If not then please explain fully, and provide more on expected results.

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,698
    Articles
    0
    Excel Version
    2010 on Xubuntu
    And BTW in a formula like SUM(B2-E2) the SUM function is redundant. (B2-E2) works great
    Thank you Ken for this secure forum.

  4. #4
    That worked perfectly. Thanks for the help.

  5. #5
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by CDAVIS0721 View Post
    That worked perfectly. Thanks for the help.
    Sorry - Which post are you replying to?

  6. #6
    your post. Thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •