Excel columns

Closed
PJ - 16 Sep 2009 à 14:38
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 16 Sep 2009 à 23:09
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?
Related:

1 response

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

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