+ Reply to Thread
Results 1 to 4 of 4

Counting cells with multiple criteria? Stock/Product counting

  1. #1
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Counting cells with multiple criteria? Stock/Product counting

    Hi, I'm no expert at Excel but I was hoping somebody could point me in the right direction.

    Im creating a stock inventory (items shipped) spreadsheet where order details are copied in from a csv file. There could be hundreds of orders there with different products and the quantity they have ordered. What Im trying to do is create a formula which would recognise the product name and count the quantity shipped in the column next to it. I would then have a table which could total how many of each product has been shipped on that day.

    I've attached a file as a basic example of what I'm aiming to accomplish. Any advice of the sort of formula I'd need would be greatly appreciated.
    Attached Files Attached Files
    Last edited by BPSJACK; 03-01-2012 at 06:14 AM.

  2. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Counting cells with multiple criteria? Stock/Product counting

    You need a VLOOKUP formula.

    In H3 paste this and drag down to further cells beneath. =VLOOKUP(G3,C3:D6,2,FALSE)

  3. #3
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Re: Counting cells with multiple criteria? Stock/Product counting

    Brilliant! Thanks for your help, I'll start reading up about VLOOKUP.

  4. #4
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Counting cells with multiple criteria? Stock/Product counting

    Don't forget to extend the table array (C3:D6) to the full extent of your data. C3 to bottom of col D or whatever. I'm sure you'll get it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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