countif

I have a list of words. And now I'm trying to ensure that they are all unique. If I take a copy of that list and RemoveDuplicates, then that removes duplicates, IRREGARDLESS of case. I then place a COUNTIF against that list to find the duplicate which has a count of 2. I then remove all...

Hi, we have the following table where we want some results 1- total count of data (as result sheet) 2-Last date of entry for the product Data SnoDateP CodeC...

Worksheet 'Dashboard' has a weekly breakdown for production numbers. I have tried multiple ways and continue to get formula errors. I need to count the number of entries in multiple other worksheets as follows: Worksheet: DG_Procedures has table DG_Table with column Date Submitted to QC. I...

Hi all, Hoping someone can help me with this. I'm guessing it super simple, but I can't find a solution anywhere online. Basically, what I'm trying to do is count the number of times each cell in a range (G4:G9) is not blank and is less than 70% of the value of the cell that is 2 columns...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hello, hope you can help. I would like to use a formula to give the count of complete projects in [time range] where there is a total of <=1 hour spent on 'review' over the whole project - example sheet below. In this sample the desired answer is 2 as only project A and B meet the criteria...

Hi, So I am trying to count how many male and female officers are on per shift, I have made a sheet so that the male officers are under one column and the female officers are under another then i put column next to the officers with an M or F. This is a separate sheet to the main sheet i want...

Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...

I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...

The conditioning formatting worked when using "cells that contain" but other forums say that it has to be a formula to then use count function. Please can someone help without using macros as I don't understand these.

Hello, I want to insert "yes'/"no" in columns I & J below based on if each row has 3 No's or 3 Yes's but the cells are non sequential, how would I write this? using a countif or an ifthen? Required skills Met Yes Required skills Met No Total hours Count Total hours Met Yes Total hours Met...

Hi, I am a beginner Excel user and I have been researching a problem. I cannot figure it out so I thought I would ask this forum. I am looking to combine a COUNTIF and an IF statement into one formula to arrive at my answer (Yes or No) for a survey type of project. Basically, I want to count...

Hello, I have been trying to get this to work for about 6 hours and I am at the end of my rope. I am pulling data from another spreadsheet in the workbook and since the locations of the data can sometimes change I am trying to make a COUNTIF formula from values entered on the spreadsheet in...

Hello! I am trying to calculate a running total of specific groups, but I do not want a group to be counted if it does not have a posted date. Currently, I am using the following CountIF formula: (=COUNTIF($H$6:H7,H7)). This formula is effective in helping me find the running total of unique...

Hello and help! I am trying to set up a conditional formatting formula that highlights similar values in the same column (Column U) listed more than 2 times. The issue is that I need the formula to only match the text before the "/" character, since the number will always be unique. Example...

Hello, I'm having some trouble combining two Conditional Formatting rules to work across two columns instead of using them individually. Currently, I'm using the following to highlight the cells in the Author and Series columns based on a named range (lstPreferred): Used in Author column (D)...

Hi all, For some reason I can not find the fix for a an easy Countifs function. =COUNTIFS($D13:$S13;">"&3;$D1:$T7;Overview!$B13)/VLOOKUP(B13;Table2[#All];2;FALSE) leads to an error while below one is working fine as it should be, but this formula is not convenient to drag down since I have to...

Hi and good afternoon, I am struggling to get a formula for countifs to work and i beleive this is due to my criteria ranges not being of the same size. Is there any work around to this? i have put my example below but the actual data set is much larger but i have the same problem. the data set...

Based on this table, I need help on creating a formula in K3 to count and in K4 to sum based on the following condition In K3 --> countif B1:G1 = K3, A3:A5 = K1, B3:G5 is number...

Hi, I have a list of codes (column A), and amounts of money (Column B). I would like to sum all of the codes but where the codes are the same, only have the sum for the first instance of that code from the list. eg see the example below TIA CODE AMOUNT RESULT CAT 5 11 DOG 6 16...