+ Reply to Thread
Results 1 to 4 of 4

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

  1. 02-12-2020, 12:39 AM #1
    ZANDRY10085
    ZANDRY10085 is offline
    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
    Reply With QuoteRegister To Reply
  2. 02-12-2020, 01:00 AM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

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

    Try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dave
    Reply With QuoteRegister To Reply
  3. 02-12-2020, 01:06 AM #3
    ZANDRY10085
    ZANDRY10085 is offline
    Registered User
    Join Date
    01-08-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    36

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

    thx for your big help, it work
    Reply With QuoteRegister To Reply
  4. 02-12-2020, 01:09 AM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

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

    You are welcome. Thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. INDEX MATCH alternative similar to COUNTIFS, but pastes values, not counts -> huge matrix
    By John 314 in forum Excel Formulas & Functions
    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. Multiplying COUNTIFS using a VLOOKUP table rather than making lots of COUNTIFS
    By DIAL90 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1