+ Reply to Thread
Results 1 to 6 of 6

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

  1. 01-21-2024, 12:05 PM #1
    SPWEx
    SPWEx is offline
    Registered User
    Join Date
    01-21-2024
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    3

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

    Hi

    I need to be able to make a selection from a drop down box and when a specific selection is made I.E. "Yes" it will subtract the number from the total amount remaining.

    I need to be able to also complete this over multiple cells

    I have attached a sample spreadsheet

    You will see there are two items with High Priority on them and there is a '2' in the total column above

    When yes is selected as complete I need it to remove 1 unit from the total numberFire Risk Assessment - Template 04-01-2024.xlsx
    Reply With QuoteRegister To Reply
  2. 01-21-2024, 12:09 PM #2
    AliGW
    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,323

    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
  3. 01-21-2024, 12:46 PM #3
    SPWEx
    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
  4. 01-21-2024, 12:48 PM #4
    AliGW
    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,323

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

    That’s what it does.
    Reply With QuoteRegister To Reply
  5. 01-21-2024, 01:04 PM #5
    SPWEx
    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

    Unfortunately its not working on my document. Thanks for the help
    Reply With QuoteRegister To Reply
  6. 01-21-2024, 01:50 PM #6
    AliGW
    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,323

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

    Then maybe you need to explain more clearly exactly what you want, because it does what I think you have described, and you haven’t told me what it’s doing wrong. Telling me that it doesn’t work doesn’t tell me anything useful, I’m afraid, so I don’t have any chance of knowing how to correct its behaviour to suit your needs. Sorry.
    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