+ Reply to Thread
Results 1 to 2 of 2

Simple formula needed to count cells based on item names in other cells

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Simple formula needed to count cells based on item names in other cells

    I need a formula to count how many of an item based on a list.
    WS attached

    I have 4 fruits listed in A2:A5.
    B2:B5 is where the totals for each needs to go.

    B8:B20 displays a number of each item and the item is listed on A8:A20.

    Basically need it to count how many Apples listed A8:A20 and total B8:B20 thenenter amount of Apples in B2.
    Same for the remaining 3 items.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Simple formula needed to count cells based on item names in other cells

    Try this in F2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Beth.

+ 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 item names based on the month
    By k1dr0ck in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-17-2019, 08:13 PM
  2. [SOLVED] How to count blank cells based on adjacent cells with names?
    By mutzie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2019, 08:33 PM
  3. [SOLVED] Formula Needed to count sales on one sheet based on data in multiple cells on another
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2017, 11:24 PM
  4. [SOLVED] Formula Needed to count based on entries into 2 other cells.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 08:01 PM
  5. [SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2013, 04:06 PM
  6. [SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2013, 06:22 PM
  7. Replies: 6
    Last Post: 10-17-2012, 07:32 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