Results 1 to 9 of 9

SUMPRODUCT for information of MONTH and TEXT (2 criteria)

Threaded View

mallory.chui SUMPRODUCT for information of... 10-05-2015, 09:47 PM
skywriter Re: SUMPRODUCT for... 10-05-2015, 10:03 PM
skywriter Re: SUMPRODUCT for... 10-05-2015, 10:17 PM
mallory.chui Re: SUMPRODUCT for... 10-05-2015, 10:36 PM
skywriter Re: SUMPRODUCT for... 10-05-2015, 10:38 PM
skywriter Re: SUMPRODUCT for... 10-05-2015, 10:55 PM
mallory.chui Re: SUMPRODUCT for... 10-05-2015, 11:26 PM
skywriter Re: SUMPRODUCT for... 10-05-2015, 11:33 PM
mallory.chui Re: SUMPRODUCT for... 10-06-2015, 05:31 AM
  1. 10-05-2015, 10:38 PM #5
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: SUMPRODUCT for information of MONTH and TEXT (2 criteria)

    Can you post your workbook?
    The data sample can be relatively small.

    If your report is sensitive make a copy delete all but a few rows and make up dummy info for the sensitive stuff. Leave the formulas as you tried them so I can see what is going on.

    ViewPic
    Last edited by skywriter; 10-05-2015 at 11:03 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] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1