count & count ifs

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

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

Hello Everyone, I have a following Data set Batch Invoice No. BT-1 ABC/01/2020-21 BT-1 ABC/02/2020-21 BT-1 ABC/03/2020-21 BT-1 ABC/04/2020-21 BT-1 ABC/05/2020-21 BT-1 ABC/06/2020-21 BT-1 ABC/07/2020-21 BT-1 ABC/08/2020-21 BT-2 ABC/11/2020-21 BT-2 ABC/12/2020-21 BT-2...

Hello, Thank you for your help in advance. I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below. I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to...

I have a table set that I can't sort or adjust. I want to count the number of matches in group 2 based off of group 1. In this example it would be 3. Group 1 has 3 that match group 2, APPLE, ORANGE, PEAR.... MIKE doesn't match. What formula would do this? 1 APPLE 2 corn 1 ORANGE 2...