Dsum formula interpretation
 

Can someone interptert the following formula for me?
=DSUM(rec_db,"9" CRITERIA!$C$1:$C$2-DSUM(exp_db,,"9",CRITERIA!$C$1:$C$2). I
am not very knowledegable about formulas, I recognise the range and absolute
arguments only. This formula is in a workbook I am amending. I need to
understand its function to amend it.

Dsum formula interpretation
 

Your formula results in a syntax error as you've presented it. Do you
mean:

=DSUM(rec_db, "9", CRITERIA!$C$1:$C$2) - DSUM(exp_db,"9",
CRITERIA!$C$1:$C$2)

If so, that can be interpreted as

(a) Caculate the sum of the numbers in the column of named range
"rec_db" with the heading "9" that meet the criterion in cells C1:C2 of
sheet CRITERIA.

(b) then subtract the sum of the numbers in the column of named range
"exp_db" with the heading "9" that meet the same criterion.





In article ,
maud0361 wrote:

Can someone interptert the following formula for me?
=DSUM(rec_db,"9" CRITERIA!$C$1:$C$2-DSUM(exp_db,,"9",CRITERIA!$C$1:$C$2). I
am not very knowledegable about formulas, I recognise the range and absolute
arguments only. This formula is in a workbook I am amending. I need to
understand its function to amend it.

Dsum formula interpretation
 

Hi,

And the C1:C2 is the criteria area, where the C1 title must match a title in
the first row of the ranges rec_db and exp_db and C2 contains the condition
which the formula is looking for in that column.

Cheers,
Shane Devenshire

"maud0361" wrote in message
...
Can someone interptert the following formula for me?
=DSUM(rec_db,"9" CRITERIA!$C$1:$C$2-DSUM(exp_db,,"9",CRITERIA!$C$1:$C$2).
I
am not very knowledegable about formulas, I recognise the range and
absolute
arguments only. This formula is in a workbook I am amending. I need to
understand its function to amend it.