Prev Previous Post   Next Post Next
  #1   Report Post  
BorisS
 
Posts: n/a
Default array error

I am having trouble with an array. I have a summary set of cells and four
identical sets that need to sum into it (to be clear, I need each of the
summary array cells to sum their respective cells from the four identical
areas).

I am selecting the sum cell group, entering 'Sum(first range, second range,
third range, fourth range)' (with none of those being named ranges...just
starting cell to ending cell), and then doing ctrl-shift-enter. The result I
am getting is the same in each of the sum cells, even though the input cells
are clearly all different. What am I doing wrong?
--
Boris
 
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
Simplifying array formula which evaluates as error. Richard Buttrey Excel Worksheet Functions 5 September 30th 05 02:35 AM
Error 1004 using array in Sheet select. Trefor Excel Discussion (Misc queries) 4 September 7th 05 07:29 PM
Trouble shooting#NA error in Array formula RonR Excel Discussion (Misc queries) 2 June 14th 05 09:58 PM
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error Chrism Excel Discussion (Misc queries) 4 May 4th 05 04:06 PM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 7 March 7th 05 06:29 PM


All times are GMT +1. The time now is 09:03 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"