=COUNTIF(A1:A20,"")

This will count the empty cells in the range A1:A20

Vaya con Dios,
Chuck, CABGx3



"Kevin" wrote in message
...
I would like to make a page that recognizes a column that does not have a
value in it.

e.g. If 1a,b,c have no value 1d,e,f have a value 2a,b,c have a value and
2d,e,f have no value ect ect for about 20 rows.

At the bottom of this I would like to keep a running total of all the
empty
boxes for every column.