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

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" <(E-Mail Removed)> wrote in message
news:82C65FE4-36D4-429E-AC7B-(E-Mail Removed)...
> 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