Excel columns [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I am trying to create a formula that will add 1 to a number at the top of a column if a number in the rows below are greater than 19. Any idea how to do that?

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

Try this
=IF(COUNTIF(A2:A10,">19")>0,1,0)