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