+ Reply to Thread
Results 1 to 4 of 4

SUMIF or SUMIFS with Array Criteria

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    SUMIF or SUMIFS with Array Criteria

    Hello Everyone,

    I'm having trouble putting a formula together in VBA. Here is the formula code as it currently stands:

    Please Login or Register  to view this content.
    As you can see, it is very long because I'm not sure how to put this together as an array in VBA. What I'd like the code to say is that if A5 through LastRow is "January", "February", or "March", then I would like the sum of column C for those lines. I've tried the formula below and all sorts of SUM/SUMIF/SUMIFS/OR statements and I havent been able to find something that works.

    Please Login or Register  to view this content.
    Thanks!

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: SUMIF or SUMIFS with Array Criteria

    Hi,

    Try:

    Please Login or Register  to view this content.
    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: SUMIF or SUMIFS with Array Criteria

    Works great! Thanks XOR!

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: SUMIF or SUMIFS with Array Criteria

    No worries!

+ 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/SUMIFS not working using Date fields as criteria
    By waynees in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2013, 09:24 AM
  2. [SOLVED] SUMIFS to match array of Criteria
    By amazinglazers in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2013, 06:25 AM
  3. How to SUM using some odd criteria? SUMIFS or SUMIF will not work...
    By joaolopes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 01:12 PM
  4. [SOLVED] SumIf / SumIfs with multiple Contains Text criteria
    By theweirdone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 05:22 AM
  5. Help using a list/array as criteria in SUM(SUMIFS())
    By jaredmason in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2012, 08:20 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