count & count ifs

I have four columns for attendance for each quarter. How do I count if all four are blank for a person and then total that at the end? The highlighted cells are representative the person did not attend all year.

I am looking for an automatic way to identify overlap and still count totals acurately. This might take a bit of explaining. In the table below, Columns A,B and C show values 1 through to 50 group in data sets. The first row, I am looking at lines 1 through to 10 which is a total of 10 lines...

Hi, I have a question and would kindly ask for your help to figure this out. Table 1, represents the date in which each product was acquired and the price paid for it. I want to perform a search in this table so it returns the price of a product to its closest registered date. TABLE 1...

These cells are conditionally formatted to be red if the cell directly above is less than it and green if it's greater than. Each cell contains a simple function of SUM the row to the left plus the cell directly above it. I'm pretty new to Excel so I've been testing functions out, and now I'm...

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...