Results 1 to 4 of 4

Add if multiple criteria met including some criteria that share a column

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    North London
    MS-Off Ver
    Excel 2016
    Posts
    28

    Add if multiple criteria met including some criteria that share a column

    Hi
    I have all data on one spreadsheet and need it to calculate on another worksheet if multiple criteria is met, the problem im having is asking Excel to calculate if there is more than one criteria in the same column.

    Im using the following formula but it will only calculate the cells in column C with (3) Tender, i need it to also count if it has (4) Presentation

    =SUMIFS(Breakdown!F2:F10,Breakdown!B2:B10,"WS",Breakdown!C2:C10,{"(3) Tender","(4) Presentation"},Breakdown!H2:H10,"New Business")

    I have attached the spreadsheet, basically im trying to ask Excel to add up the values in column F if column B has WS and column C has (3) Tender or (4) Presentation and column H has the words New Business

    side note - i have to have (3) and (4) with brackets as this is how it exports from our database - can delete each time if i really have to though
    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. Count which includes multiple columns including multiple criteria
    By Zou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2017, 10:43 AM
  2. Using Multiple Criteria (Including Dates) for a Vlookup
    By PaulMcCudden in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-23-2015, 01:16 PM
  3. Replies: 16
    Last Post: 05-25-2015, 08:51 AM
  4. Replies: 3
    Last Post: 03-28-2014, 10:17 PM
  5. Max, Min, & Std Dev with Multiple Criteria Including a Wild Card
    By rmmohan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2013, 12:45 PM
  6. Looking for last entry using multiple criteria including date
    By ayrmad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 11:36 PM
  7. sumif with multiple criteria (including daterange)
    By TPS Tom in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-28-2011, 07:43 AM

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