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)))

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

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

.

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/