+ Reply to Thread
Results 1 to 9 of 9

Sum function count help

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    Greece
    MS-Off Ver
    MS Office 2017
    Posts
    44

    Sum function count help

    Καταγραφή (8).PNG


    I want some help in my file, if user add 5 or 6 then he adds hours in cell Night Work Hours, i want to count max to 48.

    If user add D then remove by -1 in cell Hollidays... i want to remove from 48, e.g 47 46 45 44 43 ..... 0.

    and if user add R then remove by -1 in cell Day Off... i want if add R on holidays table days then count +1
    Attached Files Attached Files

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,587

    Re: Sum function count help

    You were warned about this yesterday, but didn't bother to respond. This kind of action gives you a bad reputation which will dissuade answerers from responding.



    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.
    We have a shiny new rules page.
    Please check them out here.

  3. #3
    Registered User
    Join Date
    08-29-2018
    Location
    Greece
    MS-Off Ver
    MS Office 2017
    Posts
    44

    Re: Sum function count help

    https://www.excelguru.ca/forums/show...T-function-MIN

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

    Re: Sum function count help

    Have you posted this question in any other forums?
    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 someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  5. #5
    Registered User
    Join Date
    08-29-2018
    Location
    Greece
    MS-Off Ver
    MS Office 2017
    Posts
    44

    Re: Sum function count help

    Quote Originally Posted by FDibbins View Post
    Have you posted this question in any other forums?
    Yes but i dont understand my rule problem... (but English sorry) What is the cross-posted? I must delete the other forum posts?

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    5,901

    Re: Sum function count help

    Quote Originally Posted by FDibbins View Post
    Have you posted this question in any other forums?
    OP also cross posted at MrE
    Be aware that this forum is insecure ! (images are not secure) - Use at your own risk

  7. #7
    Valued Forum Contributor
    Join Date
    05-05-2018
    Location
    Oakland, CA
    MS-Off Ver
    2016
    Posts
    483

    Re: Sum function count help

    Quote Originally Posted by hackertom View Post
    Yes but i dont understand my rule problem... (but English sorry) What is the cross-posted? I must delete the other forum posts?
    Hi,

    Re-read Post # 2, you Don't need to delete Any Post anywhere, what you Do need, is to post the Links of All your other Posts at other sites/forums here.

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

    Re: Sum function count help

    Apologies for any confusion.

    No, do not delete anything anywhere (as jtakw said). All we need is for you to provide the links to wherever else you have posted this question (and also post links in THOSE sites, to anywhere you have posted this)

    The reason for doing this is so that members - on any of the sites - dont waste their time answering a question that may already have been answered on another site.

  9. #9
    Registered User
    Join Date
    08-29-2018
    Location
    Greece
    MS-Off Ver
    MS Office 2017
    Posts
    44

    Re: Sum function count help

    https://www.mrexcel.com/forum/excel-...idays-e-g.html

    i use this 3 sites, its ok now? but this has deferent question...
    Last edited by hackertom; 09-15-2018 at 11:16 AM.

+ 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