Results 1 to 6 of 6

Extract a value in a range with specific date, category name, and store name

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Extract a value in a range with specific date, category name, and store name

    I need help writing a formula that will extract the number of "Donuts" purchased in Column "B" on my spreadsheet that looks at Column "A" and the value extracted is based on store name and date.

    i.e. Store Name: 069 - 331381 - CAFE
    Date: 07/29/2018

    On my spreadsheet I have 4 stores listed in Column "A" and it is a report for 1 week so each store has 7 different days of donuts purchases. I created a graph to the right and color coordinated it by store. I was hoping someone can help me write a formula that will find the values based on the store name and the specific date.

    Thank You in advance for anyone who can help me.

    Jason
    Attached Files Attached Files
    Last edited by JGREEN17; 08-08-2018 at 05:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] if formula on multiple criteria otherwise extract data
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2018, 11:13 AM
  2. Replies: 4
    Last Post: 05-31-2017, 09:41 AM
  3. Dynamic Formula Extract Data For Multiple Criteria - Version 2
    By Karroog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2016, 01:38 PM
  4. Replies: 12
    Last Post: 03-13-2016, 01:20 PM
  5. Writing a formula for returning a text value based on multiple criteria
    By DataAnalyst215 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2016, 06:55 PM
  6. Matching multiple criteria from Sheet1 in Sheet2 and writing it in Sheet3
    By smgjob in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2015, 06:16 PM
  7. [SOLVED] Dynamic Formula Extract Data for multiple criteria
    By Karroog in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2014, 04:08 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