Search notes:

Excel: Worksheet functions that can be given a criteria

Worksheet functions that can be given a criteria include

averageIf(), averageIfs()
countIf(), countIfs()
dGet()
dProduct()
filter()
maxIfs(), mminfs() (Is there no maxIf() or minIf()) ?
sumIf(), sumIfs()

See also

The autoFilter object.