Making a cell = 1 if the cell => 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Pat,

=COUNT(A1:A100)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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
Click to expand...
to add up is the number of units I have:
 
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
 
Back
Top