EXCEL is still a usefull program  Right???????

EXCEL -> Blockchain 

The blockchain will someday eliminate the Excel program.
Before that, Excel will be an important program for the company for about 10 years.

so, Excel Formulas > Name Manager  .   

It's very important skill~!!!!

you want to select the area    ... for   Name Manager

and Enter the Name you would like to......    In black bold border "B4" ~!!!! ex.  i will enter "Com"

then you can call this area (Name Manager ,  "Com" ) anytime
 

 Tip: I think that the best of number type is "Times New Roman" ~!!!!!

let's do it the same way.    "a_score",    "b_score",   " c_score"    

a_score : C4:C6 area  /  b_score : D4:D6  /  c_score : E4:E6

ex) mouse select area "E4:E6" and "C_SCORE" appears in the upper left corner.

Function be Used as follow~!!!!!

Why  is "SUM" in the function expression ???

The sumif function can get the sum of the conditions I want

and Name Manager view "SUMIF(Com, B9, C_score)"

a score and a Company is 89(C4) + 80(C6) = 166

very easy~!!!!!! excel ability!!!!!!!