+ Reply to Thread
Results 1 to 10 of 10

Function start count from a number

  1. #1
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Function start count from a number

    i use this formula :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    to count -1 when price is NW13 cell.

    how to star count from 100?

    e.g. 100 (-1) = 99 (-1) = 98 (-1) = 97 (-1) = 96 ............... 0 ?
    Last edited by topmayra; 09-16-2018 at 05:09 AM.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Function start count from a number

    Maybe

    =100-SUMPRODUCT(--(B8:$B400<>""),-(B8:B400=NW13))

    A formula is meaningless if we can't see the data it is manipulating.

  3. #3
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Re: Function start count from a number

    Quote Originally Posted by jason.b75 View Post
    Maybe

    =100-SUMPRODUCT(--(B8:$B400<>""),-(B8:B400=NW13))

    A formula is meaningless if we can't see the data it is manipulating.
    i upload a file in first post, check the Holiday this year NL column, i want to create this function there, I edit function cell in first post...

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Function start count from a number

    Try this one

    =100-COUNTIF(B8:NI8,$NY$9)

  5. #5
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Re: Function start count from a number

    [ delete ]
    Last edited by topmayra; 09-16-2018 at 07:18 AM.

  6. #6
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Re: Function start count from a number

    Quote Originally Posted by jason.b75 View Post
    Try this one

    =100-COUNTIF(B8:NI8,$NY$9)
    working thanks! it is possible to stop to 0 and not go to -1? maybe popup a window error if is <=0 ?

  7. #7
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Function start count from a number

    You could apply a data validation rule to B8:NI8 using formula

    =NL8>=0

    Which would kick up a warning box when you try to enter more than the permitted count of 'V's in the row.

  8. #8
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Re: Function start count from a number

    Quote Originally Posted by jason.b75 View Post
    You could apply a data validation rule to B8:NI8 using formula

    =NL8>=0

    Which would kick up a warning box when you try to enter more than the permitted count of 'V's in the row.
    it is possible to add 2 validation rules? Because in this cells run defferent rule: =B$6<>""

  9. #9
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Function start count from a number

    Sure

    =AND(B$6<>"",$NL8>=0)

    If it doesn't work as you need it to, then the other option would be to use conditional formatting, maybe turn the whole row red when =$NL8<0.

    I only suggested data validation because you asked if a pop up message was possible. Data validation is the only way to do that without using vba.

  10. #10
    Registered User
    Join Date
    09-15-2018
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    11

    Re: Function start count from a number

    Quote Originally Posted by jason.b75 View Post
    Sure

    =AND(B$6<>"",$NL8>=0)

    If it doesn't work as you need it to, then the other option would be to use conditional formatting, maybe turn the whole row red when =$NL8<0.

    I only suggested data validation because you asked if a pop up message was possible. Data validation is the only way to do that without using vba.
    ok thank you friend!

+ 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. [SOLVED] Count number of times a number appears with count start from next cell of last occurr
    By lesliewheeler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2018, 09:34 AM
  2. Count number of days from a start date to today BUT end at a certain date
    By delene_tabone in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2018, 12:56 AM
  3. [SOLVED] How to start count after 4 times the number show up
    By davi65 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 11-05-2016, 03:12 PM
  4. [SOLVED] Count Week numbers given start and finish week number
    By Vassen in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-30-2016, 01:59 AM
  5. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  6. Replies: 2
    Last Post: 08-16-2013, 08:45 AM
  7. count number of workdays from a start date
    By asmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2012, 01:12 PM

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