Totals for tally sheet

  • Thread starter Thread starter No name
  • Start date Start date
N

No name

I need to create a tally sheet in which I will indicate by letter certain
information. There may be more than one letter in a cell. I need to be
able to total the number of times in a particular row or column a particular
letter appears. For example, a single cell may contain the letters "DFO",
while another cell may contain only an "F". I need to be able to count the
number of times the letter "F" appears, the number of times the letter "D"
appears, etc. Each appearance will represent a single count, so if there
are 35 "F's" on the worksheet, I need to be able to come up with the number
35 as a total, either as a sum of rows/columns or as an overall total.

Any suggestions? Email would be appreciated. Please delete the obvious to
get my email address:

(e-mail address removed)

Thanks in advance for your assistance.
 
Try =COUNT(FIND(the letter you search for,your range)), entered as an
array formula with Ctrl+Shift+Enter
Ilan
 
Back
Top