In a formule how do you skip some rows?

[Captain Randy]

I have columns A B C D E F; I was working with formule

=countif(A2:E2,">.0000").
The trouble this formule counts all the columns between A to D.

I just want to see if A2 is greater then E2 and count it. The count should be 1, I get a count of 4.

With the powerful minds in this group I know someone has it on the top of there head.

Thank You in advance for your help and input.

 

[AlphaFrog]

I just want to see if A2 is greater then E2 and count it. The count should be 1.

Try something like this...

=IF(A2>E2,1,0)

Or this...
=(A2>E2)*1

 

[Captain Randy]

Hello Alphafrog
The formule you gave me once I worked with it for a few times, yours was
=IF(B2>E2,1,0) for some reason it just did not want to work.
So I just change the columns around.

=IF (E2> B2,1,0) It worked on the first few coulmns it looked go so I runned all the way down..

I say to you, "Thank You, Sir" great job.

Once again this group came through again.