Results 1 to 5 of 5

Wildcard to exclude specific word from list when using SUMIFS

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2023
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    57

    Wildcard to exclude specific word from list when using SUMIFS

    Hi,


    I am looking for a way to exclude the columns where "Group Quality" is included.
    I'm using this formula. The wildcard should be a part of the SUMIFS part of the formula.

    Formula: copy to clipboard
    =IF(EOMONTH(TODAY();-1)>=V$2;SUMIFS($R$3:$R$10;$Q$3:$Q$10;$B3;$S$3:$S$10;V2);C3)


    I'm attaching an sample. the formula is in the green cells.


    Project A - Group Quality
    Project A - Development
    Project A - GPDM
    Group Quality - Project A
    Project A - Development
    Project A
    Group Quality
    Project A - Development

    thanks,
    Thomas
    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. Sumifs with Wildcard in the Range
    By gruebz1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2022, 12:59 AM
  2. [SOLVED] Exclude a specific value from drop down list
    By saurab8 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 01-22-2020, 08:10 PM
  3. Sumifs and countif using a wildcard
    By FredFitzgerald in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2016, 12:25 PM
  4. [SOLVED] Exclude Values From List That Contain Specific Text
    By strother1990 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-29-2015, 11:50 AM
  5. SUMIF with wildcard, need to exclude a criteria
    By dhabersaat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2014, 08:44 PM
  6. Excel 2007 : sumIfs statement, with wildcard?
    By allison4403 in forum Excel General
    Replies: 2
    Last Post: 06-16-2011, 07:02 PM
  7. Replies: 3
    Last Post: 11-12-2009, 04:42 PM

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