excel & countifs

Hi all! I am pretty new to going beyond just the basics within excel. Currently, I am trying to clean data that is pretty simple but I want to automate the process as much as possible. Basically, participants from a survey were given a list of statements numbered 1-27 and then asked to list...

Hi, I'm making a break list at my new job for my team. Because the list has multiple entries we are forced to concentrate unnecessarily to calculate how many agents are on break. It would be helpful for my colleagues to see how many agents are on break right now, since we have a rule of no...

Hi, I'm trying to do a count of specific substring in a range of cells. I've been able to count for substrings in a cell using the following formula: =COUNTIF(A1:A3,"*fox*") However, I'm running into trouble when the substring I'm counting for exists in the same cell in another string...

Hello, You may remember me from before, I was helped to full through three different attendance types. It works lovely and I'm still trying to understand it... haha... I've come into another road bump. I had somehow figured out how to do countif with counta (I did it in a trance and was...

I have a spread sheet with the following columns: <tbody> User name Date Time Time of Day Error Code Status John Doe 11/1/2016 12:25:01 AM 123 Success John Doe 11/1/2016 8:25:00 PM 123 Success Jane Doe 11/1/2017 8:25:00 AM 234 Failure </tbody> So I want to count how many times...

Hi all, I have this formula which provides a percentage of column B count for a Yes or No answer. =COUNTIF(B6:B6345,"YES")/COUNTA(B6:B6345) =COUNTIF(B6:B6345,"NO")/COUNTA(B6:B6345) I need to know if there is another formula I could amend the above to so it counts visble fields only after i...

I have a database in excel where columns hold lots of different pieces of data. On a different sheet I would like to be able to perform a SUM within a COUNTIFS statement. The logic in my head is this, but obviously it does not work...

Hi all, my first query. I always lurk on this forum for help on things but this time my googling skills have failed me so I just had to suck it up and make an account. :biggrin: A little about me and my motivations: Over the past 10 months I have been upskilling myself. I am a novice in...

I am trying to create a formula that will count the number of "Overdue" people instead of "Overdue" cells. Each person has the multiple rows with their name in it. The criteria to determine if it's "overdue" is: -Column F and G are not within 3 years -Column G are blank -Column F = 0 and...

Hello, I am fairly new to excel and formulas and am trying to learnt he best i can :) I am a bit stuck on a formula which I can't seem to work out... I have a spreadsheet of invoices we have sent out to our customers for each pay period, I have a tab for each pay period with a list of names...

Hi, if i had cell value for example =21+22 answer should be 2 as it has used 2 value in the formula =41+40+41 answer should be 3 as it has used 3 value in the formula now in adjacent cell i need the count of values in that formula <tbody> =21+22 2 =41+40+41 3 </tbody>

Hi, Is it possible to associate =today() to if this is an example: the current tab i'd like for it to change from EMEA to AMER if today the work time is 10 PM onwards and be change to EMEA if the shift was changed to 5PM, is that possible can i kindly ask for help please thank you Absent AB...

Hi, I have data in excel which contains alphanumeric values like "NA", blanks and spaces, as well as numbers as percentage: For example, I have the 17 values in a column which includes 3 percentage numbers, 11 NA and rest blank values: <colgroup><col></colgroup><tbody> 2.37% NA NA NA...

Am I able to use the ABS function on this formula somehow? =SUM(COUNTIFS('Sheet1'!A$2:A$191,{"0*","1*","2*","3*","4*","5*","6*","7*","8*","9*"},'Sheet1'!E$2:E$191,">"&F8)) I tried the following but it is not working...