Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

Sum and Dlookup

Experts, I need to sum [Amount] on tblDisbursement_Amounts.  
I have tried to input the word sum but I am off somewhere.

Let me know where to put the word Sum and the parenth

=DLookUp("[Amount]","[tblDisbursement_Amounts]"
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
pdvsaProject financeAuthor Commented:
I am not sure if Dsum is better?
0
 
SimonCommented:
Use DSUM instead of DLOOKUP...

=DSUM("[Amount]","[tblDisbursement_Amounts]" )

This link shows the syntax : https://support.office.com/en-ie/article/DSum-Function-08f8450e-3bf6-45e2-936f-386056e61a32

The third argument is optional, if you need to specify criteria.
0
 
pdvsaProject financeAuthor Commented:
Perfect.  thank you

I added the criteria:
=DSum("[Amount]","[tblDisbursement_Amounts]","[ID_disb]=" & [ID_disb])
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now