Dsum formula interpretation

  • Thread starter Thread starter maud0361
  • Start date Start date
M

maud0361

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