Excel columns

Closed
PJ - Sep 16, 2009 at 02:38 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:09 PM
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

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 16, 2009 at 11:09 PM
Hello

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