Functions

[Neil]

Hello, I have 6 columns and numerous rows of data. Columns
1 and 2 are temperatures from one area, 3 and 4 are from
another area etc. What I am trying to do is count how many
times 1>2 3>4 etc e.g

column1 column2 column3 column4 column5 column6
2 3 4 3 4 3

the result should be 2, as 3>4 and 5>6

Thanks for any help.

 

[acw]

Neil

Try
=SUM(((A2:A5>B2:B5)+(C2:C5>D25)+(E2:E5>F2:F5)))
array entered and with the ranges updated according to the
data you have.


Tony