+ Reply to Thread
Results 1 to 3 of 3

Sumproduct SumIf using Data Ranges

  1. #1
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    Sumproduct SumIf using Data Ranges

    I saw a few similar post but the suggested formulas are not working for me.

    In data name range DISTRICT there is either a number 1 or 2. In data name range FY12CLOSEDCOUNT is where the values where the values are that I want to add up.

    So if the district is 1 I was to add the value in the same row to the running sum.

    Here is what I have tried for district 1

    =SUMPRODUCT(SUMIF(District,1,FY12ClosedCount))
    Last edited by shuddle; 10-17-2011 at 09:41 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Sumproduct SumIf using Data Ranges

    You shouldn't need SUMPRODUCT, this is sufficient normally

    =SUMIF(District,1,FY12ClosedCount)

    I'm assuming that District and FY12ClosedCount are both single columns - is that right?

    District and FY12ClosedCount should be defined so that they are the same size (and start on the same row)
    Audere est facere

  3. #3
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    Re: Sumproduct SumIf using Data Ranges

    The columns were different sizes. It now works. thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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