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