^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
|