countifs arrays

  1. E

    need to count days at jobs per employee

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

    COUNTIFS Formula Not Working

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

    How to put countif function into array formula?

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

    SUMPRODUCT(COUNTIFS(INDIRECT

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

    Using a formula that populate specific list based on list of conditions

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

    Countifs with multiple criteria OR

    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")...
  7. A

    Need help with Excel function

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

    Countifs with 900 different criteria!!!

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

    Countifs with Dynamic data on Google sheet

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

    Countifs / sumproducts to count value based on column header

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

    Counting if a unique identifier corresponds to another unique identifier more than once

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

    countifs with multiple variables from multiple columns

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

    COUNTIFS - dragging formula across cells while adding to the range

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

    SUMPRODUCT unique Values

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

    Countifs of appearance within the same Groups listed in a column

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

    Count number of rows where two columns values are matching and third column is null.

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

    count unique values based on multiple criteria

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

    Google Sheets SUM + CountIfs formula not working

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

    countifs arrays

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top