+ Reply to Thread
Results 1 to 2 of 2

Sumproduct with conditions?

  1. #1
    Registered User
    Join Date
    02-07-2009
    Location
    Avondale, Arizona
    MS-Off Ver
    Excel 2003
    Posts
    1

    Sumproduct with conditions?

    I was looking through one of my old sheets and came across this:

    =SUMPRODUCT(--(I4:I1151=3),--(J4:J1151=1))

    I can't remember for the life of me how I figured out that would count the occurrences of the two conditions. Any idea what the "--" does? If I take them out excel doesn't count any instances where the criteria are met.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    11-02-2003
    Location
    Birmingham, UK
    MS-Off Ver
    Office 365
    Posts
    127

    Re: Sumproduct with conditions?

    I'm not an expert on binary conditions, but whenever I feel the need to use sumproduct I have this link in my favourites to provide me with lots of advice on how this works.

    http://www.xldynamic.com/source/xld.SUMPRODUCT.html
    Terry

    "... I thought I was a power user of Excel until I came onto these boards..."

+ 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