Adding letters =sum(a1:a10,"T") ?

  • Thread starter Thread starter AndrewWent
  • Start date Start date
A

AndrewWent

I have a column of letters T or F representing true or false. I would like to
check through this column and count the number of Ts and/or the number of F's
and I'm having problems doing so. I've used the count function - no luck with
my structure.

Thanks

Andrew
 
You must log in or register to reply here.

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

Counting how many numbers and letters appear in a particular row 7
Excel Sum numbers in cells that also contain text 34
Creating sequential numbers plus a letter 4
scrabble excel template 2
Error when using Sum command 3
Variable row number in Sum($A$1:A10) formula 3
Scrabble Value calculation for Welsh words 0
Excel VBA 1

Back
Top