I only want to count a cell of numbers as one. For example in each cell there
are the number of contacts a person has made. But I only need to enter the
number 1 to indicate that there were contacts being made. Then I will add up
the total of people making the contacts.

Extremely vague...

Maybe this:

=COUNT(A1:A10)

That will count how many cells in the range contain numbers.

If you have something like this:

A1 = 1,10
A2 = 2
A3 = 3,5,4

Then try this:

=COUNTA(A1:A10)

That will count all the non-empty cells in the range.

If neither of those is what you had in mind then we'll need a better
explanation of what it is you want to do.

--
Biff
Microsoft Excel MVP


"Laundone" wrote in message
...
I only want to count a cell of numbers as one. For example in each cell
there
are the number of contacts a person has made. But I only need to enter the
number 1 to indicate that there were contacts being made. Then I will add
up
the total of people making the contacts.

How is your data arranged? Can you post an example

'the below will count the number of cells in col A with numbers
=COUNT(A:A)

'the below will count the number of cells in col A with numbers greater than 0
=COUNTIF(A:A,"0")

If this post helps click Yes
---------------
Jacob Skaria


"Laundone" wrote:

I only want to count a cell of numbers as one. For example in each cell there
are the number of contacts a person has made. But I only need to enter the
number 1 to indicate that there were contacts being made. Then I will add up
the total of people making the contacts.