Forum Discussion
Excel understanding
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
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.
