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 wantand Name Manager view "SUMIF(Com, B9, C_score)"
a score and a Company is 89(C4) + 80(C6) = 166
very easy~!!!!!! excel ability!!!!!!!