Forum Discussion
Reading text as a number
Hi, I need excel to read a cell of text as a number basically. More detail: Sold column is where I put the last name of customer. After several "sold columns" (that's the heading) I have a total sales column. I need it to add up those cells with last names in them. Is this possible? Pretty sure I've seen it done before.
4 Replies
I dont know if i understand your problem fully also I am kinda new to the formulas in excel, so my method maybe the long way around, but..
I would have a column A with a bunch of names, then i would create a second column B and it would have a formula like =IF(A1="","0","1"). Then that would create this column that just has a 1 next to it for every name in it. If A1 has nothing in it, its a 0, if not its a 1. Then i would probably hide that column and put an auto sum equation somewhere i want to see it. Thats how i would get a name to reflect as 1. but im not sure if you need each one to reflect an individual number? So essentially you would end up with this number that is equal to the amount of names you have in colum A.
Nevermind, I figured it out.
- What was it?
Had to use the =countif formula.
