Results 1 to 10 of 10

Sumproduct/COUNTIFs or With Index & Match in matrix table from different sheet

Threaded View

  1. 03-23-2020, 01:27 AM #1
    ZANDRY10085
    ZANDRY10085 is offline
    Registered User
    Join Date
    01-08-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    36

    Sumproduct/COUNTIFs or With Index & Match in matrix table from different sheet

    Hello, I need a Help

    I have a Selling out data with Sales Name, Item Name, Shop name
    I want to count how many shop under specific sales name who buy specific item name in specific month.
    please see Attachment.

    thx for your help
    Attached Files Attached Files
    Last edited by ZANDRY10085; 03-23-2020 at 10:00 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need a Help with COUNTIF/COUNTIFS with matrix table from different sheet
    By ZANDRY10085 in forum Excel General
    Replies: 3
    Last Post: 02-12-2020, 01:09 AM
  2. [SOLVED] Index,Match,CountIF Formula NOT working for removing duplicate rows frm Table- plz, Check?
    By sumans054 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2019, 11:28 PM
  3. [SOLVED] Vlookup, indirect, index, match, countif from multiple sheet & with two criteria
    By avk in forum Excel General
    Replies: 8
    Last Post: 10-14-2014, 01:54 AM
  4. Trying to get rid of #N/A when using Index and Match in a Matrix
    By boynejs in forum Excel General
    Replies: 11
    Last Post: 03-26-2014, 12:48 AM
  5. Correlation matrix to be populated from a 4 col table -tried if, match, and, index, arrray
    By jasonleewkd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2014, 01:12 PM
  6. [SOLVED] INDEX MATCH a table of X's pulled from another sheet.
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 10:29 PM
  7. Help Match Index Formula for a table matrix
    By prkhan56 in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 04:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1