Results 1 to 4 of 4

Counting cells with multiple criteria? Stock/Product counting

Threaded View

  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.

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