Excel understanding

Copper Contributor

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


1 Reply


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.