Making a cell = 1 if the cell => 1

[Pat]

I am entering inventory numbers into cells. All I want to add up is the number of units I have

ie.

id numbe

20
20
20

Total number of units =

Anybody have a sugestion for me

Thank

 

[Bob Phillips]

Pat,

=COUNT(A1:A100)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[steve smallman]

Hi,

you don't want to add, you want to count

at the bottom of the list enter =Count(A2:A50) assuming
your range of values excluding the column header is a2 to
A50.

This will count the number of non blank entries.

Steve

-----Original Message-----
I am entering inventory numbers into cells. All I want

to add up is the number of units I have:

 

[Pat]

Thanks for the suggestion on "COUNT". My new problem is that some of the cells contain text AND numbers and I still want it to count. The syntax you gave me seems to count only the cells with numbers. ie:

Vehicle number

102
104
256
A01
A11

total = 3 (should be 5)


Pat

 

[Frank Kabel]

Hi Pat
try
=COUNTA(A1:A100)

Frank

 

[Pat]

Thanks Steve

COUNTA works

Pat

 

[Pat]

Thanks Bob

That did the trick. COUNT

Pa

 

[Pat]

Thanks Frank

COUNTA worked well

Pa