Arrays or sumifs

  • Thread starter Thread starter Cresta
  • Start date Start date
C

Cresta

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif wildcard for text and numbers 2
How to use Sumifs with vertically and horizontally criterias 3
SUMIF and SUMIFS Error 3
Shorten multiple sumifs 2
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 1
SUMIF with criteria "<>" & "=" 4
Refer a column in the 'sumif' function 2
help with sumif formula 3

Back
Top