Sumif not Sumproduct
 

I have a large workbook sumarising data from a worksheet database. In a
previous life this book used sumproduct extensively - to recalc the book took
over 30 minutes. Now i'm using sumif, concatinated fields and re-named ranges
after data sort to get the same results on the same PC in less than 5
minutes. Obviously, I don't want to go back to sumproduct - which brings me
to the question - is there any way to use multiple criteria in sumif?
TIA
--
David

^Hi David
no. That's why SUMPRODUCT is used :-)

"David" wrote:

I have a large workbook sumarising data from a worksheet database. In a
previous life this book used sumproduct extensively - to recalc the book took
over 30 minutes. Now i'm using sumif, concatinated fields and re-named ranges
after data sort to get the same results on the same PC in less than 5
minutes. Obviously, I don't want to go back to sumproduct - which brings me
to the question - is there any way to use multiple criteria in sumif?
TIA
--
David

You could always uses SUM (IF as array formulae if SUMPRODUCT is taboo, but
that seems same problem to me.

--
HTH

-------

Bob Phillips
"David" wrote in message
...
I have a large workbook sumarising data from a worksheet database. In a
previous life this book used sumproduct extensively - to recalc the book
took
over 30 minutes. Now i'm using sumif, concatinated fields and re-named
ranges
after data sort to get the same results on the same PC in less than 5
minutes. Obviously, I don't want to go back to sumproduct - which brings
me
to the question - is there any way to use multiple criteria in sumif?
TIA
--
David

Frank,

Thanks for your response.
Recalculation time, SUMPRODUCT = 30 min, SUMIF (+concatination) = 5 min
Why would anyone use sumproduct in this instance??

Also, and I suspect the answer is *no*, is there any way to use multiple
criteria with sumif?



"Frank Kabel" wrote:

^Hi David
no. That's why SUMPRODUCT is used :-)

"David" wrote:

I have a large workbook sumarising data from a worksheet database. In a
previous life this book used sumproduct extensively - to recalc the book took
over 30 minutes. Now i'm using sumif, concatinated fields and re-named ranges
after data sort to get the same results on the same PC in less than 5
minutes. Obviously, I don't want to go back to sumproduct - which brings me
to the question - is there any way to use multiple criteria in sumif?
TIA
--
David

Hi David
maybe you post your SP formulas. Probably the ranges are too large.
multiple criteria: As stated: No way

"David" wrote:

Frank,

Thanks for your response.
Recalculation time, SUMPRODUCT = 30 min, SUMIF (+concatination) = 5 min
Why would anyone use sumproduct in this instance??

Also, and I suspect the answer is *no*, is there any way to use multiple
criteria with sumif?



"Frank Kabel" wrote:

^Hi David
no. That's why SUMPRODUCT is used :-)

"David" wrote:

I have a large workbook sumarising data from a worksheet database. In a
previous life this book used sumproduct extensively - to recalc the book took
over 30 minutes. Now i'm using sumif, concatinated fields and re-named ranges
after data sort to get the same results on the same PC in less than 5
minutes. Obviously, I don't want to go back to sumproduct - which brings me
to the question - is there any way to use multiple criteria in sumif?
TIA
--
David