Results 1 to 8 of 8

SumIF works, SumIFS doesn't

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    SumIF works, SumIFS doesn't

    I can't figure out what I'm doing wrong. I want to sum the Sep-Dec values where Position = 00079571 and New Acct = 1001. I can do a SumIF for either condition and it works fine, but when I try to do a SUMIFS for both conditions I get a value error. I use SumIFs often, so this one has me scratching my head. I'd appreciate help.
    =SUMIFS(G9:J59,C9:C59,C9,K9:K59,K10)
    =SUMIF(C9:C59,C9,G9:J59)
    =SUMIF(K9:K59,K10,G9:J59)
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMPRODUCT/SUMIFS Dynamic array doesn't works
    By regoroes in forum Excel General
    Replies: 5
    Last Post: 01-04-2018, 03:01 AM
  2. SUM function works...SUMIF & SUMIFS do not. Please help.
    By archi2this in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2015, 07:29 AM
  3. Need help debugging an Add-In that sometimes works and sometimes doesn't
    By damjanovic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2014, 05:19 PM
  4. My VBA Macro Sometimes Works and Sometimes Doesn't
    By chsaav in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 09:10 PM
  5. ListBox works, then doesn't
    By Bagharmin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2011, 12:18 PM
  6. [SOLVED] Sub works sometimes and sometimes doesn't
    By Barry O''Connell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2006, 10:10 PM
  7. it works, it doesn work, its works....and so on.
    By Naz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-30-2005, 09:05 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