countif, countifs
https://songforruach.tistory.com/entry/%EA%B5%AC%EA%B8%80-%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8-%EC%B4%88%EA%B8%89%ED%8E%B8-5
averageif, averageifs
https://songforruach.tistory.com/entry/%EA%B5%AC%EA%B8%80-%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8-%EC%B4%88%EA%B8%89%ED%8E%B8-7
vlookup
특정 범위를 지정해서 조건에 맞는 결과값을 추출하는 함수
=vlookup(비교값, 참조범위, 열번호, 일치옵션)
참고:
신규 추가 행에 vlookup 적용하기 (Arrayformula)
https://dsconsulting.tistory.com/entry/%EA%B5%AC%EA%B8%80-%EC%8B%9C%ED%8A%B8-%EC%8B%A0%EA%B7%9C-%EC%B6%94%EA%B0%80-%ED%96%89%EC%97%90-vlookup-%EC%A0%81%EC%9A%A9%ED%95%98%EA%B8%B0-Arrayformula
*