Excel understanding

[limnitech]

Hello Please could you tell me what the below means as there is no example

'For example, if the range G1:G2 contains the column label Income in G1 and the amount $10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions

Thank you and God Bless

Madalina

[#2]

@limnitech 

See the screenshot below.

A1:C11 is a database-like table.

G1:G2 is the criteria range.

The formulas in G4 and G5 count and sum the incomes equal to $30,000.

The first argument in DCOUNTA and DSUM is the database range.

The second argument is the column you want to refer to.

The third argument is the criteria range.