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