Results 1 to 7 of 7

SUMIFS with multiple conditions Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    372

    SUMIFS with multiple conditions Formula

    I have a SUMIFS formula (in highlighted yellow in attached file) and is summing based on criteria. However, my formula is not adding up as I want to. I think it's because I want it to sum two criteria in the same column (Fixed Bid or T&M or both)- it could one or the other or both. If the formula would work correctly, it would total $769,279 for all DEPTS... what am I doing wrong?

    Formula: =SUMIFS('V Dump'!AB:AB,'V Dump'!$D:$D,DEPTS!$D$2,'V Dump'!$N:$N,DEPTS!$G$13,'V Dump'!$K:$K,DEPTS!$D31,'V Dump'!$M:$M,DEPTS!$D28,'V Dump'!$M:$M,DEPTS!$E28)

    Refer to attached sample file -
    Attached Files Attached Files
    Last edited by rz6657; 02-09-2015 at 02:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looking for something simpler than SUMIFS - SUMIFS
    By YAbdelaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2014, 10:38 AM
  2. Sumifs
    By pickslides in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2014, 01:34 AM
  3. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  4. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  5. [SOLVED] IF and/or SUMIFS
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-12-2012, 09:12 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