+ Reply to Thread
Results 1 to 2 of 2

sumproduct vs. countif

  1. #1
    Coal Miner
    Guest

    sumproduct vs. countif

    Question - I have a so-called 'database' of about 15000 rows of data. From
    the so-called 'database' I am performing sumproduct type computations. I do
    not believe I can use the countif function since I am looking at either 2 or
    3 columns of data to extract the proper value (e.g. I can not use countif x
    +/- countif y +/- countif z). My question is this - Does the sumproduct
    function take a long time to perform calculations? Here are a few of my
    formulas

    =SUMPRODUCT(('Jan Database'!$C$2:$C$19992=C15)*('Jan
    Database'!$P$2:$P$19992=TRUE))

    =SUMPRODUCT(('Jan Database'!$C$2:$C$19992=C15)*('Jan
    Database'!$P$2:$P$19992=TRUE)*('Jan Database'!$Q$2:$Q$19992))

    =SUMPRODUCT(('Jan Database'!$C$2:$C$19992=C15)*('Jan
    Database'!$P$2:$P$19992=TRUE)*('Jan Database'!$K$2:$K$19992))

    These are all working properly, just a little slow for the user.




  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    SUMPRODUCT has always been rather slower for me as well, but unless you are writing your own function (which run slower than built in ones) I can't think of a better way to do it. (Maybe someone else can though)

+ 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