| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Sumifs | Excel Worksheet Functions | |||
| Trouble with arrays (transferring values between two arrays) | Excel Programming | |||
| SumIfs | Excel Discussion (Misc queries) | |||
| Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
| Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
Hybrid Mode
