If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Array formula in merged cells
I have a simple array formula that sums 3 criterias. After I've entered
the formula and do Ctrl+Shift+Enter, an error pops up stating that "Array Formulas are not valid in merged cells.". I am a novice to array formulas so this is strange to me. Any way around this? Thanks, VT |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Arrary formula for Average includes blank cells | jan | Worksheet Functions | 4 | May 14th, 2004 11:19 PM |
Excel formula - select cells based upon fill color and then sum | Worksheet Functions | 0 | May 13th, 2004 07:45 PM | |
Excel formula - select cells based upon fill color and then sum | Peo Sjoblom | Worksheet Functions | 1 | May 13th, 2004 06:52 PM |
Can't Sort Worksheet - Merged Cells Must be Identically Sized | Setting up and Configuration | 1 | February 4th, 2004 02:18 AM |