if statement
 

hi i was jus wondering what the code would be if i wanted to create an if
statement where for every empty value in the cells from B2 to B29 would add
1. i had this code but it would only add 1 for when the whole field was
blank. this is the code that i was using.
=IF(B2:B29="", (1),)
hope that you can help

if statement
 

Maybe

=COUNTBLANK(B2:B29)

Mike

"Kieran" wrote:

hi i was jus wondering what the code would be if i wanted to create an if
statement where for every empty value in the cells from B2 to B29 would add
1. i had this code but it would only add 1 for when the whole field was
blank. this is the code that i was using.
=IF(B2:B29="", (1),)
hope that you can help

if statement
 

Maybe =COUNTIF(B2:B29,"")


Gord Dibben MS Excel MVP

On Tue, 4 Mar 2008 00:37:01 -0800, Kieran
wrote:

hi i was jus wondering what the code would be if i wanted to create an if
statement where for every empty value in the cells from B2 to B29 would add
1. i had this code but it would only add 1 for when the whole field was
blank. this is the code that i was using.
=IF(B2:B29="", (1),)
hope that you can help