Arrays or sumifs
 

Hello
Can anybody tell me if changing a 3 criteria sum(if( array formulas to
sumifs formula is worth doing, and why.
We are moving Excel 2003 files to 2007 and would like to know if changing
these forumla would speed the files up any.
Thanks

Arrays or sumifs
 

Yes, they should be far more efficient.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Cresta" wrote in message
...
Hello
Can anybody tell me if changing a 3 criteria sum(if( array formulas to
sumifs formula is worth doing, and why.
We are moving Excel 2003 files to 2007 and would like to know if changing
these forumla would speed the files up any.
Thanks