+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Sumifs with Multiple variants

  1. #1
    Forum Contributor
    Join Date
    11-28-2011
    Location
    St. Louis, Missouri
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    129

    Sumifs with Multiple variants

    I have a formula that is setup like this to count multiple variants:

    {=SUM(COUNTIFS(saleslogpromo,{"999","9999","B998","B999","G998","G999","M998","M999","N998","N999","SB","Y998","Y999","111","333","PI","222","XTV","CS"},saleslogrep,V2,purchdate,">="&W2,purchdate,"<="&X2,Sales_Verifier,{"ad5550";"jv5026";"ts8953";"cf7714";"nl2589";"sh1346";"mf7708"}))}

    I want to be able to do a sum like this, here is what I have and it doesnt work:

    {=SUMIFS(inboundcalls,callsrep,V2,callsqueuenum,{"5018","5030","5031","5032","5033","5034"},callsdate,">="&W2,callsdate,"<="&X2)}

    Let me know what and how I manage this, I would rather not do multiple sumifs + together if at all possible.

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    11-28-2011
    Location
    St. Louis, Missouri
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    129

    Re: Sumifs with Multiple variants

    So I change the countifs to sumifs, =SUM(SUMIFS( and seemed to work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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