Array Formula

[Guest]

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:K60>J10:J60,1,0)}

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

 

[Peo Sjoblom]

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:K60>J10:J60))

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon