Results 1 to 4 of 4

Need a Help with COUNTIF/COUNTIFS with matrix table from different sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    36

    Need a Help with COUNTIF/COUNTIFS with matrix table from different sheet

    I need a help about Countif/Countifs

    please look at the Attachments file,

    i have data in sheet1, just say data about selling with item name (A,B,C,D) , Month (jan 2019-jan 2020), and selling count


    what the formula in (sheet2) "B2", if i choose "A2" and "B1" with the option there,
    it will give the result about countif "A2" when "B1" > 0 data from sheet1

    thx for your help, sry for my bad english
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-09-2019, 12:44 PM
  2. [SOLVED] COUNTIF/SUMPRODUCT(?) to create a matrix from data
    By diamond chap in forum Excel General
    Replies: 27
    Last Post: 11-25-2019, 10:52 AM
  3. Replies: 6
    Last Post: 03-19-2019, 09:14 PM
  4. [SOLVED] Cooccurrence matrix construction with countifs
    By clw496 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2016, 08:36 AM
  5. Link cell fill colors of Sheet 2 matrix to Sheet 1 matrix
    By runnerD2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2016, 12:01 PM
  6. Countif and Countifs
    By alexfamily5 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-15-2013, 05:51 PM
  7. Using data contained in a matrix table on another sheet
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2010, 01:50 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