Dsum formula interpretation

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

JE McGimpsey

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

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top