+ Reply to Thread
Results 1 to 6 of 6

How to get an instant sum

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    toronto
    MS-Off Ver
    2013
    Posts
    3

    How to get an instant sum

    I have the following form based on a table:
    Please Login or Register  to view this content.
    fields “empname” and”salary” are locked, but the working is field is able the be switched between “yes” and “No” by the operator by a click.

    Is it possible that the "summary" shows the instant sum of salaries of the employs whose working status is “yes”? For example all “working” are yes and summary shows 2700. But the operator clicks on the working status of Steve and changes it to NO, and the summary right away shows 1200.

    i am not sure if this is doable on a form or report.
    thank you

  2. #2
    Registered User
    Join Date
    08-21-2012
    Location
    London
    MS-Off Ver
    Office 365 MAC
    Posts
    45

    Re: How to get an instant sum

    Perhaps SUMIF will work for you?
    Learner, making mistakes, asking daft questions.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    44,515

    Re: How to get an instant sum

    Hi, welcome to the forum

    I agree that you could probably use SUMIF() for this
    =sumif(criteria-range, criteria, sum-range)
    to give more detailed help, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,266

    Re: How to get an instant sum

    Is this not an Access query?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  5. #5
    Valued Forum Contributor
    Join Date
    08-13-2008
    Location
    Καθαρτήριο
    MS-Off Ver
    2010 primarily
    Posts
    782

    Re: How to get an instant sum

    You could use a DSUM function in a textbox.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    44,515

    Re: How to get an instant sum

    Quote Originally Posted by AliGW View Post
    Is this not an Access query?
    or perhaps pulled in from another app, numbers under "salary" look wonky

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1