+ Reply to Thread
Results 1 to 3 of 3

COUNTIFS and MATCH functions

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    21

    COUNTIFS and MATCH functions

    Hi All. I'm using Excel 2010 and I am used to using COUNT, COUNTIFS, AVERAGEIFS etc. but I'm stuggling with working out how to use MATCH and COUNTIFS. Obviously these may not be my best options so any help would be appreciated.

    The problem is I have 3 colums of Data: A includes the date of a sale; B includes the Company if was sold to; C the Value of the sale. It centers upon finding out how many times a Company bought over different periods of time. I am trying to populate a second sheet. I have enclosed an example.

    Many thanks in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: COUNTIFS and MATCH functions

    I like to use SUMPRODUCT for this kind of calculation. Attached is an example.

    Good luck!
    Attached Files Attached Files
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: COUNTIFS and MATCH functions

    Thanks tuph. I'm familiar-ish with SUMPRODUCT how would I use it to fill in the info on sheet 2?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countifs Until Criteria Is Match
    By Zipmeister in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2013, 12:34 PM
  2. VBA: Help with countifs / Match
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-29-2012, 01:42 PM
  3. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  4. Countifs with OR functions
    By bellpiero in forum Excel General
    Replies: 2
    Last Post: 03-17-2010, 12:12 PM
  5. Replies: 0
    Last Post: 11-15-2007, 05:24 AM

Tags for this Thread

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