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
|
|||
|
|||
Would use Array formulas but....
I am studying examples of array formulas just to get the
feel of them so I can use them when needed. But the message I get when entering the formula insists that "Array formulas are not valid in merged cells". There are no merged cells in this example. I think I know what a merged cell is, and I don't have any in this example. So, what REALLY is the problem with this formula. I could put some data in the example, but I tried to keep the size of the post down. =SUM(IF($B$1:$B$25 120000, IF($h$1:$h$25.125,1,0))) |
#2
|
|||
|
|||
Would use Array formulas but....
Try copying your data to a brand new sheet and pasting just values, then if there is a hidden merrged cell somewhere screwing you up you'll eliminate it.
Personally I think merged cells are nothing but trouble and I never use them |
#3
|
|||
|
|||
Would use Array formulas but....
Nope that doesn't work. I just copied out of an example on
the web. Is there some setting in the Excel program that could produce such a messge? -----Original Message----- Try copying your data to a brand new sheet and pasting just values, then if there is a hidden merrged cell somewhere screwing you up you'll eliminate it. Personally I think merged cells are nothing but trouble and I never use them . |
#4
|
|||
|
|||
Would use Array formulas but....
Hi,
I was testing the formula and it worked to me. I use excel 2002 in Spanish, so you will have to replace the names of the functions. I think that the problem was in the separators that you were using. =IF(SUM(B1:B10)120000;IF(SUM(H1:H10)0,125;SUM(B1 :B10);0)) Also, you must see what separating decimal is setting in your system. We used the comma "," and you would have to use the dot "." --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please help..activating array formulas in a range of cells without going cell by cell | Karenna | Worksheet Functions | 3 | March 1st, 2004 03:45 AM |
Array formulas will not copy. | Steve Clarian | Worksheet Functions | 1 | October 31st, 2003 02:25 AM |
create array of values returned by named formulas | Rob Hick | Charts and Charting | 4 | September 27th, 2003 04:53 AM |