+ 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
    47

    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 Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    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.
    Please familiarise yourself with the rules before posting. You can find them here.

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

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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

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

    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
    O365 v 2402
    Posts
    13,443

    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

  7. #7
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    47

    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)

Similar Threads

  1. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  2. User defined function- count color and count only visible rows
    By marsjanik1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2016, 03:05 PM
  3. How to count text entered with ALT+ENTER using a count function
    By bethy1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2015, 02:41 PM
  4. [SOLVED] COUNT function does not count values beginning with text
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2013, 06:38 PM
  5. [SOLVED] Count If Function To Count Frequency Of Long Numbers
    By RowanB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 05:18 AM
  6. Using the COUNT function to count letters generated by an IF function
    By SMErickson7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2013, 12:02 PM
  7. Replies: 2
    Last Post: 06-23-2009, 11:16 AM

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