ǹ
[ Լ] ͺ̽(Database) Լ
* ͺ̽ Լ
database criteria ´ ڵ带 ã
field ʵ带
function Լ ϴ ԼԴϴ.
: =Dfunction(database,field,criteria)
: Database - ̽ ù ʵ
ڵ, ʵ ۼ
մϴ.
Field - ʵ ʵ忡 Էµ
ĺ ֵ ϴ ̸μ
̽ ù ϵǾ մϴ.
ʵ ̸ Էµ Ϲ ϱ Ͽ
ٸ Ͽ մϴ.
Criteria - ã ϴ ˻ ϴ
ù ˻ ϰ ϴ ʵ ϵǾ ϰ
ʵ Ʒ ʵ ˻ϰ ϴ Էմϴ.
* ͺ̽ Լ
1) DAVERAGE
ͺ̽ Ͽ ã ǰ ġϴ մϴ.
2) DCOUNT
ͺ̽ ʵ忡 ã ǰ ġϴ
ڰ ִ ϴ.
3) DCOUNTA
ͺ̽ ʵ忡 ã ǰ ġϴ
ִ ϴ.
4) DMAX
ͺ̽ ʵ忡 ã ǰ ġϴ ū մϴ.
5) DMIN
ͺ̽ ʵ忡 ã ǰ ġϴ մϴ.
6) DSUM
ͺ̽ ʵ忡 ã ǰ ġϴ մϴ.