Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|