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.

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