How to count how many times a number appears in a spreadsheet? [Solved]
Ask a questionkimipapineau3PostsThursday July 14, 2016Registration date
July 15, 2016
Last seen - Last answered on Jul 15, 2016 11:20AM
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??