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
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.
