ExcelBanter - Array Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Array Formula (https://www.excelbanter.com/excel-worksheet-functions/71713-array-formula.html)

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:K60J10: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:K60J10:J60))

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"sarah" wrote in message
...
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:K60J10:J60,1,0)}

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