Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 15th 06, 09:27 PM posted to microsoft.public.excel.misc
Coal Miner
 
Posts: n/a
Default 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   Report Post  
Old June 15th 06, 09:34 PM posted to microsoft.public.excel.misc
kraljb
 
Posts: n/a
Default sumproduct vs. countif


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)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552467



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct, If, Sumif, Countif, Match?? Herman56 Excel Discussion (Misc queries) 0 March 30th 06 01:40 PM
countif more than one sheet/tab and sumproduct BSantos Excel Worksheet Functions 1 February 23rd 06 06:20 PM
countif, sumproduct mg New Users to Excel 7 July 1st 05 10:26 PM
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R. Excel Worksheet Functions 2 February 24th 05 05:57 AM
SUMPRODUCT & COUNTIF Connie Martin Excel Worksheet Functions 2 December 16th 04 06:53 PM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017