Numbers update automatically when certain values are selected

C

CDAVIS0721

New member
Joined
Mar 4, 2017
Messages
3
Reaction score
0
Points
0
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.View attachment MISSIONS FIRED REPORT.xlsx
 
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. :)
 
And BTW in a formula like SUM(B2-E2) the SUM function is redundant. (B2-E2) works great
 
You must log in or register to reply here.
Back
Top