countif

Based on this table, I need help on creating a formula in K3 to count and in K4 to sum based on the following condition In K3 --> countif B1:G1 = K3, A3:A5 = K1, B3:G5 is number...

Hi, I have a list of codes (column A), and amounts of money (Column B). I would like to sum all of the codes but where the codes are the same, only have the sum for the first instance of that code from the list. eg see the example below TIA CODE AMOUNT RESULT CAT 5 11 DOG 6 16...

I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using: =SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129)) In fact, this works perfectly when sorting smallest to largest: In a ranking of 125...

Hello All, I have a workbook that non-Excel people use. It records the progress of the elevator car we're installing. It's a free-form table where users can enter their car IDs anywhere in the "Car" column (see the example). I want to count cars "not started" as a data point. Unfortunately...

Hello! I need to look up an article number in a table and return a text associated with this number. A pretty easy task it seems, BUT I can't get it right! The workbook has two sheets I recieve article numbers from one program with some content I past this content in "Materiallista". In...

Hello Friends, I have a workbook and there is 6 question and i'm really confused abouth than so if anyone can help to ans those question I will very helpfull and appreciate your help. File Link Thank you.

Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...

Hello, I am trying to do the following with a COUNTIFS Formula G:G = "In Survey" AF:AF = "" (Blank) AD:AD = <>"" (Populated with data, but not specific) My original formula looked like this: =COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,"<>""") However with or without data in AD...

Hi, I am trying to do a few things based on the below sheet. Essentially I have a long sheet of dates broken down by year ,month ,day hour...etc. I aim to have a rolling count of the total number of rows for each year. So column "percentcounter is an example of what I would expect to see. It...

Hi all! I am currently comparing values in two sheets to each other to see if they are similar or dissimilar. I have this setup at the moment: My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...

I need to count all specific values in column B, only when column A contains a date within the last 90 days. Can anyone assist me with this?

Hi, I'm trying to create a new rota for my workplace [Google Sheets – image below- Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4). I'm currently using...

Cells A-H in blue refer to workbook 'Dan Participants'. Columns A and B are linked to an external data source. I have used the CONCAT function to merge the names together from cell A and B. Cell H references the internal worksheet 'Vacancies', cells C and K coloured red. The formula works as...

I have a data table with multiple columns. I need to count the number of occurrences of names in the range --> Summary!$C$3:$D$10000. The name list is located on Sheet1!$A$2:$A$8 I want the total count to be Sheet1!$B$2:$B$8 If the same name is shown in the adjacent column cell, I only want to...

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...

I am attempting to count the number of cells in column A that are formatted with different colors (Green, Yellow, Blue, Orange, empty, etc.) and place the total in column M. I have tried =countIf( ...) and many others. Is there a Filter command I can use? Any advice is welcome. I thought...

Hi! I'm trying to create a folrmula to search in different columns and if all cretiria match, then it will return the result. For example: A B C D E F G 1 kids cushioned sportive socks 2p kids socks 2p 2 pack socks for kids If B1 contains all word cretiria from columns D,E,F...

I have 2 sheets, Sheet1 and Summary. In Sheet1, the first row contains text that may or may not be contained in column C of Summary. I am trying to copy and paste the values in Summary's column D alongside column C matches to Sheet1's first row (the data in Summary is already grouped by column...