count & count ifs

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

I'm trying to count how many times the same Date is repeated in a range. This is what I have so far, and is not working. Sub counting() <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...

I have a sheet with dates listed in columns B:12 to C:15 in a table. Column "B" is "Start" and column "C" is "End". Column A:12 to A:15 has a drop down list with choices of "Not Started", "Started", "Completed", and "Cancelled". The sheet calculates how many dates remain for the day, week...

Ask Question Ask Question <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;"> up vote1down votefavorite I...

The problem that I am having with the countifs function is that the function is seemingly counting less than it should. Each function has the same syntax, expressions, and operators in it, so there should be a great deal of variability that seems improbable Furthermore, Each function is counting...