Are you stuck on Excel or Google Sheets?

Need to count a Specific text for specific name in a range

I need a help in analysis of one seconds data for frequency reading on the national grid. I have to count number of events when frequency below certain point was recorded below certain frequency point for certain period of time

I have a range of cells and would like to use a formula to count the unique values occurring in the range.

I need a formula to count days from an historic date to current date

I have many cells where value is seperated by commas e.g- 1,5,7,8,9 3,0,4,7,8,9,52, Just want to count total value, in the above case it should be 12

Need to sum a count of Sales which were refunded for a specific person.

Is it possible to have a function (like a COUNTIF) that will count sells that meet specific criteria, but the range is limited to the 10 cells in the range that immediately precede a blank cell? So for example, the general range is A1:Z1, but I want the range to be specific to the last ten cells immediately prior to the first blank cell in the general range. Thank you.

I need a formula that would check for various criteria in a range of cells and count the ones that meet the required criteria

Hi there, I have data that has Week Number, Day and shift colour (Red or BLue) and need a formula that would count and bring back the details such as how many times Blue on week 16 on Mon and not anything else (hope this makes sence)

Hi all, Having a little drama with a roster redesign I'm doing. Each employee has a row, 365 cells long, representing the entire year. Days off are marked "X", while days worked are filled with a numerical start time. To ensure the employees are rostered as equally as possible, I would like a way to count the number of blocks of >7 consecutive shifts. What this means is the number of times there is at least 7 cells between two cells which contain "X". The count is then used in a separate sheet to compare against other employees. I've nutted out how to count the number of weekend shifts for my other analysis, but this one has me stumped. Any help appreciated!