Would use Array formulas but....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)))
 
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
Click to expand...
just values, then if there is a hidden merrged cell
somewhere screwing you up you'll eliminate it.
 
Hi,
I was testing the formula and it worked to me. I use excel 2002 i
Spanish, so you will have to replace the names of the functions.
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 ".
 
Back
Top