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
|