How to count how many times a number appears in a spreadsheet? [Solved/Closed]
kimipapineau3
Posts Thursday July 14, 2016Registration date
July 15, 2016
Last seen

Jul 14, 2016 at 03:44 PM  Latest reply: kimipapineau3
Posts Thursday July 14, 2016Registration date
July 15, 2016
Last seen
 Jul 15, 2016 at 11:20 AM
I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadsheet. I have the formula =COUNTIF(B6:M59,"1") but that only tells me how many times only the single digit 1 appears. I need to count how many ones total even if it appears in 11, 16, 21, 51. So in the 5 numbers listed the number 1 appears 5 times. Can someone please help me??