
* averageif averageifs Լ
averageif : ϳ ϴ Լ
averageifs : ִ 127 ϴ Լ

: averageif(C3:C8,"",D3:D8)
: 1. C3:C8 ԵǾ ִ մϴ.
2. "" ϴ ϸ C8̶ ֽϴ.
3.D3:D8 մϴ.

----------------------------------------------------------------------------------------------------------------------

: averageifs(D3:D8,C3:C8,"",E3:E8,">=70")
: 1. D3:D8 մϴ.
2. C3:C8 ԵǾ ִ մϴ.
3."" ϴ ϸ C8̶ ֽϴ.
4. E3:E8 ι° ԵǾ ִ մϴ.
5. ">=70" ϴ ϴ.

̹ Ͽ ٿε ֽϴ.
ȸ Ȯּ! ( ȭ )
ֿ̹ ûϽø, Ϻ ƺ ֽϴ.