Excel 기본 함수

sumifs
 - 계산할 열 , 조건1범위, 조건1, 조건2범위, 조건2, ... 
countifs
counta
 - blank가 아닌 셀 개수 
index
 - array에 위치 지정해주면 해당 위치의 값 반환
match 
 - 행이나 열 중에 하나는 1줄이어야 함 
vlookup
 - 조건2개이상 - =INDEX(표2[#모두],MATCH(1,  (B3=B:B)*("여성의류"=C:C)*("상의"=D:D),0),13)
                                 범위                         조건1    * 조건2             * 조건3         완전일치, 열번호  
 - ctrl shift enter - 배열(array)