Tally marks in excel

[ashima_singh]

Hi,
Can we count number of tally marks in excel a row or column and display the sum of all?

				total
Strongly agree	<strike>||||</strike>	<strike>||||</strike>	|||	=????

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>

How to calculate the total?

 

[Peter_SSs]

How are the tally marks entered in the cells?

 

[jtakw]

How are the tally marks entered in the cells?

I think it's related to this thread: https://www.mrexcel.com/forum/excel-questions/284515-tally-marks.html#post5130306

 

[Peter_SSs]

I think it's related to this thread: https://www.mrexcel.com/forum/excel-questions/284515-tally-marks.html#post5130306

I agree, but in that thread we were adding the tally marks (with the aid of conditional formatting). Here, the tally marks are already there so I was trying to elicit whether they were
- done with certain characters,
- manual formatting,
- Conditional Formatting based on some other cell perhaps,
- vba code
- something else

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-formulas-and-functions/1243424-count-tally-marks.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html