countif

Hello, Would you know why the usage of a TRUNC function into COUNTIF our COUNTIFS, as here-after, produce the following error message ? =COUNTIF(TRUNC($A$2:$A$6),D$1) The range $A$2:$A$6 contains some numbers with decimals and I aim to count how many of them matches the cell D1 that contains...

Hi, I have below table and what I need to do is to count how many repeated value in the column A, then number the results (the expected results column is what I need), anyone can help? ABC1EE IDCountifExpected...

Hello, I'm trying to attempt to put into one table both the age group the pet is in and the groups they scored into. I'm struggling with getting the two different tabs to calculate one number and the age being ">=" and "<=". Excel keeps saying I have too many arguments. Any Help Would Be...

Hello, I have a sheet with duration values. I already can count the total amount of a specific area (ex : B2:G2) to get the total of time, that's easy and not an issue. However, I would want to get à value = 1 for each cell in the area where there's a duration. So if I have : 1:00:00 [blank...

Hi all! I am trying to convert numbers in multiple columns to a value in words. I am using the =IF(COUNTIF(range,criteria),"value if true","value if false") function and able to make it work with only one criteria, but having trouble returning a value when using multiple criteria. This is what I...

Hi all, I would like to: Check if row value in Column AN can be found in another workbook's Range("D2:D30") If true, then return "APAC" in Column AM. If false, do nothing and leave row value as it is. However, my formula entered below is returning 1s and FALSE: Range("AM2")...

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...

Hi All, Newbie poster, but have used the forum a number of times! This question has been asked and answered before, but I really cannot get it to work [count of employees which were employed between two dates]. I have a list of start dates (A:A) and end dates (B:B) of employees who were...

Hi Excel Gurus, I've been working on this problem for days and tried numerous different formula to no avail, any help is appreciated! Problem: I have a list of 250,000 emails that needs to have all emails associated with lawyers removed (ex. info@lawofficexyz.com). Attempted Solutions: In...

Hi all, I have this file: How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red? Hope my question makes sense...

Hi, I want to find the most frequent occurring text in a column with multiple criteria. I know how to do this for simple criteria, but when I have to use the date criteria it gets complicated. This is working for these two criteria that I implemented...

Hi all, I'm sure I'm doing something really silly with my formula however, I've basically got a table of total number of calls made per day. In column A I have the date, and in Column B I have the call number. I'm trying to calculate the total of the calls, made within a date range specified on...

Hi. I am trying to make a dashboard for hiring and departing employees. I have two simple tables on two worksheets respectively. I'm trying to compare the two tables to determine who was hired and who quit. The input tables are made from the list of who is currently employed, which I...

Hi all, For each cell in column B, I want to count how many cells in that column have the same value. If there is only one cell in the column with that value, change the Cell.Value to Cell.Value & "a", if there are two cells in the column with that value, change the Cell.Value to Cell.Value &...

Hello, I am getting the aforementioned error with my code, and I have absolutely no clue why. Any help would be appreciated I'm clearly not understanding something. [CODE=vba]Sub MonthlyAdd() Dim Category(7 To 10) As Variant Dim Ar As Variant Dim Br As Variant Dim Catgry As String Dim i As...

Please see below example table. Column A has random numbers between 1 to 100 Column B has the following formula copied down starting from B2: =IF(COUNTIF($A$2:A2,A2)=1,1,0) I would like to get value of 1 in column B if the row in column A is distinct, else 0. This works well only for small...

I have a fairly extensive Select Case statement to translate data. What I am trying to do for Case 20 is count how many cells in the adjacent 7 columns are >0. Basically, I am trying to count how many days someone is scheduled to work based on how many hours they are scheduled that day...

Hi, I'm trying to use multiple COUNTIF to check two sets of criteria. I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria If duplicate IDs are found and the same fruit on both days it...

In A column I have data from 1 to 100, in B column I have "Yes" or "No". In C1 I want a formula total of "yes" from Serial (1 to 30) + (41 to 60) + (91 to 100), Similarly in D1 total of "yes" from Serial (31 to 40) + (61 to 90) what should be the formula ...

Hello, I am trying to look up and return all invoice #'s that were paid in the year 2021. The invoice #'s and year paid are two separate columns. I would like to return all the applicable invoice #'s in column A in another sheet. I have attempted the problem myself using the INDEX function but...