count & count ifs

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

Dear Everyone! I want to ask your help. I have read all about this forum, but the solutions i've found, not work for me in google sheets. My wife leads a Development Centre that helps little children to develop motor skills. At the beginning of a new month, she has to send a report to the...

Hey Guys, I'm creating a very large budget for 2022 and using the 2021 budget as a starting point for an IT group. I want to create unique SKU's for the existing budgeting items so we can easily manage to the new budget next year and to track spend YoY. I have created 2 digit category's based...

Hi there, I have a list of employee names, which are also accompanied by date and location information (see example). I would like to quantify how many relationships exist between the names on the same day/location. In other words, how many times has each employee worked with every other...

Hello, I need help! I need to create a formula that will help me validate data within a hierarchy rollup. As an example, I created a spreadsheet of cities with the State, Country, and Continent they map to. I'm looking to create a formula that returns a count if the state maps into more than...

Hi, I have a schedule of employees, that works in shifts. But i want to count how many people are working between 07:00 and 12:00 and between 12:00 and 16:00 and between 16:00 and 20:00 How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down...

Hello master minds :) , I have a Power BI data set with TimeStamps. Each are 15 minutes apart. I would like to create a column that counts the number of consecutive timestamps with the same StatecategoryName. This is an Excel sample of my data in columns 'G'-'I'. The results I want to...

I have a table with loads of columns. they all have a unique ID (A). In one column (K) it says a date that something was meant to be completed, in the next column (L) it says when it was actually completed. I am trying to do an analysis and show how many of the Projects (A) where delivered on time.

Okay, I am beginner/intermediate Excel user for work. Working with Excel 2010. I have a thought process in my head for what I want to happen, but cannot figure out how to execute it. I am tracking employee attendance over a 12 month rolling calendar. Here is my spreadsheet; Basically I have...

Hi All - I have a list of employees and their billing period against each contract. I need to calculate the days billed for each employee against each contract by month for last 12 months. My worksheet is as below: My expected result is as below: Thanks in advance. Regards, SSP

Hi, if it helps, i've uploaded my file to dropbox: Dropbox file I have a workbook with two sheets. one called "2020", which is the main sheet and the other called "Data", where i'm basically just aggregating data. the purpose of this file is to essentially keep track of my finances...

I have a list of companies that have a blank cell before and after each company in column C. Example: C: abc company abc company abc company abc company abc company xyz company xyz company xyz company xyz company and in column G I have an activity date if it is unique Example: B...

I have a cell with a long text string. I need to count how many times the value "004" (quotes included) shows up. I tried the search function, but it doesn't work with quotes. Also, it will only tell me if "004" exists in the cell, not how many times "004" shows up. Any help would be so...

hi, i have a table called mytransaction. in this table there is a column, R, to indicate the user has checked on the transaction. there is also another collumn call source where they select which account is involve in that transaction. so now in one of the cell i would like to count how many...

Hello. I am trying to do the following. If range A1:A1000 = "ABC" then count range B1:B1000 FYI there are formulas in range B1:B1000 so when in Excel and I highlight B1:B1000 i get a count of 1000..not sure why ....maybe because each cell has a formula ? Please Help !! Thank you.

I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help? Thank you!

Hi, I am struggling to get my head around the following, any help would be appreciated. I have the following list, and need to count the number of mixed sku/single sku pallets. In this example Pallet 1 has 2 different item codes, so need to return 1 mixed pallet, and pallet 2 has only 1 item...