Why The Fucck Can I Not Get Excel To Count or Tally How Many Times A Number Occurs in a Row of Cells?
- Thread starter Silkk
- Start date
Its hundreds of cells breh
African_brehda
Superstar
Won’t this depend on how the data is formatted?
@Silkk , how is the time data formatted? Is it dates combined with the time?
Nah every single occurence is separated in military time each day from the past 7 days.
African_brehda
Superstar
No nikka, I have chatgptIt’s 10:45pm here. I’m about to sleep, enjoy Excel
I gave guy some hope huh?
O.T.I.S.
Veteran
Military and this excel bullshyt
Legit be forgetting I have that shyt
Good looking
Fat Fred Jones
Reticent
To count how many times a specific number appears in row 2, you can use the COUNTIF function. Assuming the specific number you're searching for is, for example, 59 and you want to count it across a single row, you would enter the following formula into cell C3:
=COUNTIF(2:2, 59)
This formula will count how many times the number 59 appears in row 2. Adjust the number 59 to the specific number you are looking for, or replace it with a reference to a cell containing the number you want to count.
Or
To count how many times a specific number appears in column B, you can use the COUNTIF function. Assuming you are looking for the number 59, you would enter the following formula into cell C3:
=COUNTIF(B:B, 59)
This formula will count how many times the number 59 appears in column B. You can replace 59 with any other number or reference a cell that contains the number you want to count.
The 2:2 and B:B represent the rows and/or columns to be searched. You can adjust the numbers as necessary, for example, 2:5, would search the entire rows of 2 through 5. B:G would search entire columns of B through G. B1:G18 would search cells in that specific rectangular range. Be sure the cell with this formula is not in the search range.
=COUNTIF(2:2, 59)
This formula will count how many times the number 59 appears in row 2. Adjust the number 59 to the specific number you are looking for, or replace it with a reference to a cell containing the number you want to count.
Or
To count how many times a specific number appears in column B, you can use the COUNTIF function. Assuming you are looking for the number 59, you would enter the following formula into cell C3:
=COUNTIF(B:B, 59)
This formula will count how many times the number 59 appears in column B. You can replace 59 with any other number or reference a cell that contains the number you want to count.
The 2:2 and B:B represent the rows and/or columns to be searched. You can adjust the numbers as necessary, for example, 2:5, would search the entire rows of 2 through 5. B:G would search entire columns of B through G. B1:G18 would search cells in that specific rectangular range. Be sure the cell with this formula is not in the search range.
Last edited:
Every time I'm at work and either don't feel like working through or get stuck on a Sheets formula I ask my boy Claude from Anthropic for help and he comes thru. Literally just show it the data and tell it what you're trying to do.
really though, if you want someone here to help you, you need to post a row of the data with headers
used every day for work.. I work about 2 hours a day now. hour of input, hour of auditing said results. them long days are over. had youtube espn on the rest of the day.
I tried that and it wouldn’t let me create the thread even in spoilers
Fat Fred Jones
Reticent
Can you post an example of the values to be searched as they appear in the formula bar?I tried that and it wouldn’t let me create the thread even in spoilers
OliviaTwist
All Star
Lie about being proficient in excel brehs 
Dameon Farrow
Superstar
Use Python. shyt's probably easier than Excel. It's damn near written in English.
Sounds like you want a countif statement with it looking for the hour digit of the time( ) function.
Google how to return the hour digit of whatever format your time/date is in. I think it’s time( ) but not at my computer right now.
Google how to return the hour digit of whatever format your time/date is in. I think it’s time( ) but not at my computer right now.