Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

Need to count a Specific text for specific name in a range
Solved by V. B. in 20 mins
I have a range of cells and would like to use a formula to count the unique values occurring in the range.
Solved by E. B. in 14 mins
I need a formula to count days from an historic date to current date
Solved by T. Q. in 11 mins
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
Solved by A. H. in 20 mins
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
Solved by M. J. in 20 mins
Need to sum a count of Sales which were refunded for a specific person.
Solved by Z. H. in 18 mins
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.
Solved by O. F. in 26 mins
I need a formula that would check for various criteria in a range of cells and count the ones that meet the required criteria
Solved by T. S. in 54 mins
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)
Solved by X. E. in 8 mins
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!
Solved by M. H. in 60 mins
1 2 3 4