countifs arrays

I have a workbook that takes data from one program, tracks the hours of all the employees, and produces an upload file for another program (accounting software) that processes payroll. As these employees work multiple jobs a weeks, sometimes even multiple in one day, I need to count the days...

Hi, so I have an excel sheet here that needs the CountIFS Formula. I am not sure why it isn't working and there doesn't seem to be anything wrong with the formula but it keeps returning zero. I have tried removing the dropdown list and the data validation but it is still returning zero. Any...

Good afternoon all. We are trying to count and sum the monthly payroll for all employees #1,#2, etc. up to a certain count (in the example below, 7). Essentially, we need all the Boolean answers (see formula) to be in a sequence and then for an array formula to spit out a sum (and count...

Hi, I am attempting to use two countif conditions across multiple sheets (which I have named "Tabs" in name manager) to count how many times a job is raised for an item with a certain reference number in a particular year of its ownership. I have used a no. of forum posts to get me to where I...

Hi, I have below sample table and what I need is to populate demographics based on the count of each factor. I put the expected results based on the result of factor count of AAA, which is in this example are 4 that is based on the formula that count AAA based on selected filters from drop...

Hi! Im calculating a COUNTIFS formula with some OR conditions. However, although the first condition is met in my result, the second one only calculates the second value ("A")...

First post here and a basic user of excel. Go easy on me. I have a list of parts that were only available on certain dates (marked by 1 as available and 0 as not available in Sheet2). I have a separate table where I want to find out by part if they were available at least Y times in a X number...

Can anyone suggest a way I can do this? I get up to about 120 criteria before excel tells me that the formula is too big. Any suggestions of methods I could use to expand it to 900 (I know this sounds excessive)? Kind Regards.

https://docs.google.com/spreadsheets/d/1u2sRu7MLGYJ0aYQUEnVLED3iR7rCHqW1z0RCJEosmlI/edit?usp=sharing I have list of sales person who works in various regions. I've fetched number of calls they did on particular date but I don't want to change formulas daily. How can I use offset countif to...

<tbody> 06/10/2017 29/09/2017 22/09/2017 BA1 y y BA2 Y y BA3 y y BA4 y </tbody> Hi, This is an example of how my dataset looks. I'm looking to count the number of "Y"'s in any specified week so if I type 22/09/2017 in a cell, it would count the number of "Y"'s in that column...

I'm trying to determine how to count the number of times a text value in ID1 matches up with a text value in ID2, but the problem is that the values aren't necessarily unique. See below for some sample data: COLUMN A (ID1): SLS.123, SLS.123, SLS.123, SLS.234, SLS.123, SLS.123, SLS.299, SLS.123...

I'm in a computer work center with a daily report that shows the amount of work being done company wide each day. The return file is 14 columns that is 7000+ rows deep and I receive this file every day with new data. What I need is an individual count of the number of files from each work type...

Essentially, I am trying to count the number of "first time customers" every month. I have a list of customers and for every month, it lists how much they ordered. There will be a "0" up until their first month they order, when it will then have a value greater than 1. So in my list of...

Hi, I have table as follows: A Customer B Location C Turnover Jan D Turnover Feb E Turnover March F Etc Etc for the next 48 months I want to know how many customers in a specific location have had turnover in a 12 month period. So if Col B = C3 (C3 on a different tab), and the value in any of...

Hi I am new here. I am wondering how to do countifs with different arrays but also counting by reference to groups within a column. For example in the table below, you will see Column A, there are four groups. How do I count the number of times in which John and Elaine appear in the same group...

Hi All, I have a very strange condition where I have to get my answer in a single cell. Note: I do not want to populate any randome cell and refer that in my cell function. See the below table: COLA COLB COLC COLD 123 123 Y 223...

Hello everyone. Really struggling with something - I know this has been posted in other places, but I'm having a hard time understanding the solutions. I'm trying to create a function (not in vba) that will count the unique IDs where it fits the criteria: Date>8/2, Date<=8/7, Hours>0...

I'm using Google Sheets and am trying to get this formula to work to give the me the following count: Count when Column T = Kenneth AND Column U = (Pending OR Contacted) AND Column W has a date that falls between the dates shown in B14 and B15. This is what I have so far...

Hello, I'm trying to evaluate two ranges within a countifs formula for any potential identical values. I have a calendar/schedule sheet with the days of the week and two rows of values using a three character letter code (ABC for the sake of the formula below) and a four digit number code...