IFTHEN
 

What formula will take alpa column(s) such as names and sum as numeric?

IFTHEN
 

You'll have to give us a little more to work with.
Can you post an example of what you're working with and what you want to do?


***********
Regards,
Ron

XL2002, WinXP


"Scott" wrote:

What formula will take alpa column(s) such as names and sum as numeric?

IFTHEN
 

i have a worksheet w/ multiple columns, i have alpha data inputted in the
cells of the columns. at any given time some of the cells will not have data
in them those are totaled as zero. if the cell has data it would total as 1.
if no data in cell it would total as 0. here is example of what i am
wanting to place at the bottom of the worksheet. sorry it is so incomplete
but it is a work in progress.

occupied cells 27
empty cells 29
total cells 56

IFTHEN
 

Try this:

With
A1:A100 containing values or blanks

The count of non-blanks
A101: =COUNTA(A1:A100)

The count of blanks
A102: =ROWS(A1:A100)-A101
OR
A102: =SUMPRODUCT(--ISBLANK(A1:A100))

Alternatively
A101: =COUNTA(A1:A100)
A102: =A103-A101
A103: =ROWS(A1:A100)


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Scott" wrote:



i have a worksheet w/ multiple columns, i have alpha data inputted in the
cells of the columns. at any given time some of the cells will not have data
in them those are totaled as zero. if the cell has data it would total as 1.
if no data in cell it would total as 0. here is example of what i am
wanting to place at the bottom of the worksheet. sorry it is so incomplete
but it is a work in progress.

occupied cells 27
empty cells 29
total cells 56