Results 1 to 9 of 9

SUMPRODUCT for information of MONTH and TEXT (2 criteria)

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2015
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    9

    SUMPRODUCT for information of MONTH and TEXT (2 criteria)

    Hi all,

    I am currently working on a turnover report and i am having some problems using the countif formula to count e.g. the number of staff resigning on a certain month with a certain title.
    Capture.JPG

    I tried to search online and found that I will have to use SUMPRODUCT instead of COUNTIF for this matter as there are the month column and text column. However, I have not too familiar with this function.
    Can anyone help so that i can have the result of:
    in January, there are 1 Sales Associate leaver and 1 Senior Sales leaver and 1 Sales Associate leaver in Apr

    Note that I only look at the month instead of the date.
    thanks for your help in advance
    Last edited by mallory.chui; 10-13-2015 at 04:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct with month, year, other criteria, and blank
    By bibbi2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2015, 12:47 AM
  2. [SOLVED] Sumproduct from date - 4 criteria (inc month & year)
    By Knawl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2014, 04:48 AM
  3. Using SUMPRODUCT For Two Criteria AND Month of Year.
    By stuu3270 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2013, 06:22 AM
  4. [SOLVED] Sumproduct/text/month
    By sick stigma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2012, 03:39 PM
  5. Sumproduct using Month as one of the criteria
    By Statsman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2008, 02:21 PM
  6. SumProduct error when using Year , Month and text criteria
    By jsrobin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2008, 10:56 PM
  7. sumproduct additional information for adding another criteria
    By Darlo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2007, 11:30 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