+ Reply to Thread
Results 1 to 6 of 6

Drop Down Selection to to subtract from a Number in a cell

Hybrid View

SPWEx Drop Down Selection to to... 01-21-2024, 12:05 PM
AliGW Re: Drop Down Selection to to... 01-21-2024, 12:09 PM
SPWEx Re: Drop Down Selection to to... 01-21-2024, 12:46 PM
AliGW Re: Drop Down Selection to to... 01-21-2024, 12:48 PM
SPWEx Re: Drop Down Selection to to... 01-21-2024, 01:04 PM
AliGW Re: Drop Down Selection to to... 01-21-2024, 01:50 PM
  1. 01-21-2024, 12:09 PM #1
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: Drop Down Selection to to subtract from a Number in a cell

    Welcome to the forum.

    Try this:

    =COUNTA(C9:C20)-COUNTIF(H9:H20,"YES")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  2. 01-21-2024, 12:46 PM #2
    SPWEx is offline
    Registered User
    Join Date
    01-21-2024
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Drop Down Selection to to subtract from a Number in a cell

    Hi

    Thankyou, Unfortunately this did not work.

    When cells H9:H20 is "YES" cell C3 needs to drop count by 1

    Many Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to change custom number based on drop-down selection
    By barman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2020, 03:54 PM
  2. Create number of rows from drop down selection
    By JohnABC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2019, 02:36 AM
  3. How do I subtract a value from a specific cell from a drop down box with list of numbers?
    By t4r1q in forum Excel General
    Replies: 3
    Last Post: 10-10-2017, 03:25 PM
  4. How do I subtract a value from a specific cell from a drop down box with list of numbers?
    By t4r1q in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-06-2017, 04:29 PM
  5. Using Excel to track the number of times a drop down selection is used
    By webdeveloper in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 04:33 PM
  6. Change number format in one cell based on drop selection of currency or percentage
    By morrisg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2013, 09:38 PM
  7. Drop down list from 3 or 2 or 1 or 0 number selection
    By Joah in forum Excel General
    Replies: 4
    Last Post: 06-20-2012, 08:48 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1