LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Application hang with array sum(sumif... formula

I have an excel sheet that recalc very fast under 2003, under 2007 it never
finish. The formulat that causes the problem is an array sum of a sumif...
What I'm trying to do is sum a column if the values are equal to a range of
othe values... A typical use would be:

={sum(sumif($A:$A, G5:K5, $B:$B))}

what this does under 2003 is sums the values in column B if what's in column
A equals the contents of G5, H5, I5, J5, or K5.

As I understand it the sumif creates an array of the sumif's and then the
array sum sums all those values.

In 2003 blazingly fast, under 2007 even with one such formula it never
completes. If interested I have an example sheeet.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
and < for Array Sumif ({}) Kiwi Matt Excel Worksheet Functions 6 October 23rd 06 06:32 PM
Array Formula w/ Multiple SumIf Criteria Andy Excel Worksheet Functions 3 July 13th 05 08:56 PM
Modify SumIF... Array Formula carl Excel Worksheet Functions 2 May 17th 05 07:52 PM
Modify SumIF... Array Formula Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:15 PM
Application hang when open a schema file in Excel Iv Excel Discussion (Misc queries) 0 February 16th 05 03:05 AM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"