count & count ifs

Hello, What formula can i use to count the number of individuals joining by month and year in column E. I've tried the formula below however get a value of Zero =COUNTIFS($Q$16:$Q$4007,MONTH(6),$S$16:$S$4007,YEAR(2019)) <tbody> a b c d e 1 6 2019 john June 2 6 2019 jacob May 3 5...

Hi ALL!! I've been working on a VBA project on and off for a little while to make things easier at work. to tell you a bit about my work, I'm actually a lab analyst rather than a data analyst, so mostly I'm mucking in testing tap water rather than playing around with excel :laugh:; but each...

I have data similar to below...I would need help in getting coutif formula ...I need count based on names and it should exclude the "Zero" value lines...for each amount type... I need one count for aaaa & bbbb and rest all other names should come under other names.... <colgroup><col><col...

Need help fellow Excellers... Column G has either "A" or "B" placed in each row. Column L has either "X" or "Y" placed in each row. (The values above are internal coding. They could be any value, really) Trying to calculate the percentage of "X's" that appear in column L that are assigned to...

Hiya I've attached a picture for reference. I'm currently at work and have been trying to figure this out for hours. So my task is to figure out which person made how many of each mistake. As you can see to right I can easily find out how many mistakes total were made by each person, but now I'm...

My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes CategoryRecipe <tbody> Category (A) Recipe (B) Cat1 RecA Cat1 RecB Cat2 RecD Cat2 RecC Cat3 RecA Cat3 RecD </tbody> Next is the...

Hello everyone, I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count...

Team, I am looking for some formula to get the require project status "Yes" or "No". Here I have sample data. If you look at project name is repeating and project type have both onshore and offshore. I would need to get status "Yes" if any project worked on both project types. If in case...

Hi there - I'm trying to sum all of the data in column D that have either a yes in the primary or secondary category, but only include the first instance of that value. In the example below, the sum would be 3 (1 for A, 2 for B). Please help!! :) <tbody> Area Primary Site Secondary Site Value...

Hi Everyone, this is my first post I have found some great solutions on this site over the last few months but I can find how to do what I am looking for and was hoping someone could help me I run a spread sheet to track absence days at work and need help with how to count specific absence...

<tbody> Ref Company Date Company INV Number Sub Total Expenses Difference Grand Total Paid Credit Status Date Sum Outstanding Amount Sum by Date 1 Test 2018/10/03 Test 2018/10/03_Test0001 Test0001 R3 888,00 R2 110,00 -R 4 002,00 R 5 998,00 Yes OPEN -R 4 002,00 0,00 43377 43376 2 test...

I'm trying to auto input in sequential numbers in the COUNT (Column A) based on the invoice number (Column B) this can go go on for over a thousand records depending on how many invoice were put in the excel spreadsheet so it will vary. And is rather time stressed to do the counts manually...

Hi All I am trying to Sum the Max of consecutive numbers for cells greater equal than 2, for instance <tbody> A B C D Consecutive Sum Max 0 2 2 3 7 1 1 1 1 0 3 2 1 1 5 </tbody> Thanks!

<tbody> A B 1 AAA123 1 2 BBB123 1 3 BBB123 2 4 BBB123 3 5 CCC123 1 6 CCC123 2 7 DDD123 1 8 DDD123 2 9 DDD123 3 10 DDD123 4 </tbody> I basically need a formula to get me a running count of variables in Col A??? Stumped

Hey Guys, Having trouble solving this one. I have data that is displayed like this: England 4 France 3 Brazil 4 USA 4 USA 4 Canada 3 I'm trying to count how many times a combo of England,France occurred as a 4/3, Brazil, USA as a 4/4 and so on...the data is displayed vertically...

Hi All, Really struggling with this one. I've got a formula that counts only the visible filtered negative numbers, however, it gets more complex as I don't want it to count it if it's a duplicate in relation to a despatch number. Please see example table below. My current formula counts the...

Hi Guys, Hope you can help! If you guys could help me with this I would be hugely grateful as this would save me sooo much time every month. Basically, I want to count the number of times 1 appears in 3 or more consecutive cells. Each cell only contains a 1 or 0. <tbody> Name Apr 1st Apr...

Hi Everyone. I am working on production sheet where I need to use count function for date and time. I will explain with an example. Suppose there are 3 columns A,B,C named as "Tasks", "Date" and "Time". Whenever the operators enters "OK" in Task column, the Date and Time are automatically...

Hi, Trying to add all of occurrences of "Yes" in a particular range for all worksheets. I was hoping to use the clever trick I use for summing across worksheets: =SUM(First:Last!$E$36:$I$36) I tried using COUNTIF or AGGREGATE (using 2 for COUNT) but I get #VALUE ! error...

Hi All, Help me! I want to count the ticket numbers with following conditions. 1)Count should be according to the month and the ticket type 2)If the ticket is opened ex: March and Closed in June then the ticket is carried forward to April, May and ultimately closed in June. So the count for...