I want to type a text in a cell, but I want that text to represen.

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

Guest

I want to type text into a cell (actually the checkmark symbol in winding2)
but I want that text to represent a number. So if I have 3 cells each with
the checkmark and each of those cells represents the number 1 when I auto sum
I will get a total of 3.
 
If they represent 1 you can just count them with countif

=COUNTIF(Range,"character")


regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
# symbol appearing instead of typed text in a cell 1
Excel Sum numbers in cells that also contain text 34
Can I show text that represents a number 4
Can a Numeic Value in Excell be changed in Text 1
Changing Text To Numbers ? 1
cell function 2

Back
Top