Results 1 to 7 of 7

SUMPRODUCT with 2 criteria from date and specific text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    SUMPRODUCT with 2 criteria from date and specific text

    Hi All,
    I have a worksheet with SUMPRODUCT to get total of working days & it is working fine: =SUMPRODUCT(--(TEXT($C$4:$C$35,"MMM")=$N4)*($E$3:$L$3=O$3)*$E$4:$L$35)
    Table 1: Data Source. Table 2: Data prep

    With the additions to the above, I wish to get the SUMPRODUCT working to this current & with specific text "MC". I have tried to add another arguments to the formula but returns with #VALUE!.

    Please find attachment.
    Any help is greatly appreciated

    Thank-You very much
    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: 11
    Last Post: 09-02-2020, 05:57 AM
  2. [SOLVED] Use VLOOKUP and SUMPRODUCT to calculate total between time range for specific criteria
    By klavierkatze in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2020, 01:34 PM
  3. [SOLVED] Find array based on specific criteria to use in SUMPRODUCT function
    By cfrae84 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2015, 09:08 AM
  4. [SOLVED] Sumproduct with specific text
    By sandiptemkar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-27-2013, 12:09 AM
  5. Replies: 5
    Last Post: 02-04-2013, 05:32 PM
  6. [SOLVED] SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text
    By James T in forum Excel General
    Replies: 4
    Last Post: 05-25-2006, 03:00 PM
  7. [SOLVED] Count items when specific text and date criteria are met
    By javamom in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-24-2006, 04:35 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