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