|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
Thread Tools |
07-16-2008, 06:28 PM
|
#1 (permalink) |
|
Registered User
Join Date: Jul 2008
Posts: 2
OS: XP
|
Excell formula help!
Been trying to figure out a formula in Excel with no success. What I need is a way to covert or assign a numeric value to a name that is typed into a cell. Then create a formula that will add up those cells and display a total.
Example: Enter in A1 (john) A2 (Jim)--then have cell b1 display the total of A1 and A2 as 2. or Enter A1 (john) A2 (jim) A3 (jack)--then cell b1 would equal 3 Is this possible ?  |
|
     
|
|
07-16-2008, 06:40 PM
|
#2 (permalink) |
|
Folding Along
Join Date: May 2007
Location: PA, USA
Posts: 1,304
OS: xp
 |
Re: Excell formula help!
try
COUNTA(A1:A3) this will return a count of the cells in that range that contain text.
__________________
I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team |
|
|
|
|
07-16-2008, 06:47 PM
|
#3 (permalink) |
|
Registered User
Join Date: May 2008
Location: Baltimore, Maryland
Posts: 97
OS: Windows XP SP3
|
Re: Excell formula help!
That's good, gistek. Or, if you want to reference the entire column A, you can put this in cell B1:
=COUNTA(A:A) which will allow cell B1 to be updated when additional entries are placed in column A. |
|
|
|
|
| Thread Tools | |
|
|
