Results 1 to 4 of 4

Multiplying countif text matches within a range

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2023
    Location
    Southampton, England
    MS-Off Ver
    MS Office Online
    Posts
    5

    Multiplying countif text matches within a range

    Hi All,

    On the attached file, in the 'stock control' tab, in total stock added table I have added a counter to record each time a stock type is chosen from the drop down lists in the first 2 tables, but cannot work out how to multiply that by the quantities entered in the next column. I've put some numbers in for 'Sensor Controller' as an example, where there have been 2 orders of 20 received and 2 units returned to stock. This should mean I have 42 units of 'sensor controller' in stock, however with my very limited knowledge of using these I can only seem to make it recognise each entry as 1.

    I hope this all makes sense. Also, last time I posted a similar problem, somebody just completely did it for me - which was great, however I'm also hoping that someone could point me to some resource whereby I can learn to implement this myself next time!

    Many Thanks in Advance!
    Attached Files Attached Files
    Last edited by Gouldinho83; 04-21-2023 at 09:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 04-10-2023, 05:22 PM
  2. Replies: 3
    Last Post: 04-08-2023, 07:12 PM
  3. Replies: 7
    Last Post: 01-09-2023, 07:43 PM
  4. [SOLVED] Highlighting a Cell if the text in a range matches the text in a separate workbook range
    By TrojanHorse8806 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-02-2022, 11:55 AM
  5. COUNTIF Department Matches and Date Range-30 matches?
    By Steven8294 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2022, 06:53 PM
  6. [SOLVED] Doing a countif in one cell that only counts if data in a range of cells matches criteria.
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2017, 12:28 AM
  7. Replies: 1
    Last Post: 08-21-2015, 09:47 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