Sumif not Sumproduct

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

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

 

[Guest]

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?

 

[Guest]

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