View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.