+ Reply to Thread
Results 1 to 5 of 5

SUMIF trouble

  1. #1
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    126

    SUMIF trouble

    Hello - I'm having trouble referencing two sets of criteria to sum data that meets both criteria. I attached a sample worksheet.
    I have one data set that shows actual units for each county in California.
    I have another data set that shows which counties belong in which MSA.
    My desired result is to show the total units per MSA.
    Thanks for any help!
    Attached Files Attached Files
    Last edited by macrorookie; 08-02-2020 at 02:08 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,741

    Re: SUMIF trouble

    How about
    =SUM(SUMIFS($C$3:$C$60,$B$3:$B$60,IF(H3=$E$3:$E$60,$F$3:$F$60,0)))

    But the Counties in col F have a space after them, which you will need to remove

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,552

    Re: SUMIF trouble

    Please try at I4

    =SUMPRODUCT(SUMIFS($C$4:$C$54,$B$4:$B$54,TRIM($F$4:$F$61)&REPT(0,$E$4:$E$61<>H4)))
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: SUMIF trouble

    Thanks to Fluff13 and Bo_Ry. Great solutions.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,741

    Re: SUMIF trouble

    You're welcome & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumif trouble
    By visk92 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 01-24-2020, 11:35 AM
  2. [SOLVED] Having Trouble with SumIf
    By SabbathXXL in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-03-2015, 01:17 PM
  3. [SOLVED] Trouble with simple sumif
    By sipa in forum Excel General
    Replies: 6
    Last Post: 01-26-2015, 11:50 AM
  4. Trouble with SUMIF
    By hechtic in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-30-2014, 02:39 PM
  5. Trouble using =SUMIF
    By slope in forum Excel General
    Replies: 9
    Last Post: 06-11-2009, 04:28 AM
  6. Sumif Trouble
    By dreicer_Jarr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2009, 12:57 PM
  7. Trouble with SUMIF
    By shandy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2007, 04:55 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