software

I would like to compare a range of data in 2 different column, using an array
formula?

I need to compare if the figures in Column K is greater the figures in
Column J?

Would this be the right formula to use?

{=IF(K10:K60gt;J10:J60,1,0)}

If it is, i can't seem to get the right answer. Is there something wrong
with my formula?
--
sarah

How are you comparing, if all values in K are greater than J? If the total
of all figures in K is greater than J?
Do you want to count how many figure in K are greater than J? If the latter
use

=SUMPRODUCT(--(K10:K60gt;J10:J60))

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;sarahquot; gt; wrote in message
...
gt;I would like to compare a range of data in 2 different column, using an
gt;array
gt; formula?
gt;
gt; I need to compare if the figures in Column K is greater the figures in
gt; Column J?
gt;
gt; Would this be the right formula to use?
gt;
gt; {=IF(K10:K60gt;J10:J60,1,0)}
gt;
gt; If it is, i can't seem to get the right answer. Is there something wrong
gt; with my formula?
gt; --
gt; sarah