count & count ifs

Hello, I am trying to count how many unique kits I have in excel. (A group of rows) Each Kit Starts with a P in column G and ends with the last C, before the next P, in column G. I need a formula that can identify the kits using the above logic and count how many unique kits there are please...

lets say I have this table I would like a formula to count how many of the rows range contains the number X. for example how many row ranges contains the number 4? that would be 2 (the 4-9 and 2-5) I need this formula to be a part of a bigger one but currently I haven't managed this one yet

Hello Everyone, I was hoping anyone could help me with a formula here. There is a big table with a lot of data that I am working and I would like to count the value of the cells that have a specific text on another column on the same row. I did an example table to explain it. picture attached...

I want to count number of product which are older then a specific date count them all but duplicates once

Hi Team, I have a dataset with the below format. acct,date,resp-code 1234,0102,00 1234,0102,00 1234,0102,01 1234,0102,01 1234,0102,00 2341,0102,02 looking for the output in the below format. acct,date,resp-code,count,SuccessRate 1234,0102,00,03 1234,0102,00,03 1234,0102,01,02...

Hello, I have a set of data that I need to have a formula in my 1st row that will tell me the % of the cells that are filled in. I achieve this with a =COUNTA pretty easily but there's some issues in a couple of columns where I expect some cells to be blank. I'd like this formula to read in...

Hi All, See my table test data. I want to show a total based on the cells that are <> Not in Scope. However I want to exclude OS Upgrade Status from the formula, so those cells do not add to the count. Any of the cells that have a DNS listed are highlighted green if that helps, but can not be...

How do I count the number of items at their furthest point in a process. A couple examples: -- In an 8-phase process, it's easy to count any of the items that made it to phase 8 or to phase 7, but how do I count how many made it to phase 7 without making it to phase 8? --Similarly, when tracking...

Hi All, First time poster, long time supporter. Formula's requiring more than basic functions drive me crazy trying to fix as MS are absolutely useless in helping to solve the error in their own program! Anyway, I have a row of values in the form of percentages for KPI's and I want to count...

Hello, this is my first post in this forum. I am currently doing a mini attendance sheet for number of employees. I have two different sheets, "A" and "B". In sheet B, there are a list of employees with each of them have 4 values (date). In Sheet A, there are column of days of a month. I would...

Hi there, I am banging my head against a wall trying to have a formula that would instantly count from 1 to 100 and then reset infinitely. I assumed I could do 1 to 100 twice and then use the fill handle but that causes excel to assume I want 1-100, 1-100, 200-300, 1-100 etc Now...

I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...

Quick back story: I need to report shipping dates to customers. I gather this information by doing a two way index match on the customers PO number and the customers PO line number against our line number. When entering items into our system the Import Team is supposed create an order number...

Hi, I'd like to be able to count the number of certain words in a cell, e.g. in E4 I have Lamb, rice, coffee, coffee. In L4 (Beverages column) I want to know how many drinks have been had of either: beverage, tea, coffee ovaltine In L4 I'm using: =IF(COUNTBLANK([@[Food taken]])>0,""...

Hi, I have below table which has management chain levels from 2 to 8, and managers 11 managers. What I need to know is how to calculate the blank cells under Management Chain Level 03 for each manager. Meaning, if I filter Manager A, and filter Management Chain Level 03 by blank only, the...

Hello, Is there a way to have a formula get the total for x columns? For example the first row for Company 2 would be the total of ($10*100%) + ($10 *100%) +(10%*50%) vs company 3 which would be the total of ($20*100%) + ($20*50%). The tricky part is that company 2 on the next row could have 4...

Hi, I have a report that have all management levels (management layers) and what I need is to count how many layers under each manager from Management Chain 02. I have the below sample table and want a formula that can help with accomplishing my target. The report I have has more 8000 rows and...

Hi, I have created a formula to count the amount of times "closed" appears in column A combined with column H returning a date within a set range. =COUNTIFS(Data!A:A,"Closed",Data!H:H,">="&J2,Data!H:H,"<="&J3) What I am getting out is However source data is this Any guidance...

A B C D E Result John Daisy 00011 Britney 00100 Ronny 00100 Can we get the result in 0, 1 format by Combining Array to Text and CountA from A to E ? or if any other method?

I have two columns, AR (Program Name) and BA (Yes or No), and I want to count the number of 'Yes' responses based on the program name. I've tried COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, SUMPRODUCT without success. I get returns of 0, all the Yes', and #VALUE. I've been trying to...