countif

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

I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using: =SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129)) In fact, this works perfectly when sorting smallest to largest: In a ranking of 125...

Hello All, I have a workbook that non-Excel people use. It records the progress of the elevator car we're installing. It's a free-form table where users can enter their car IDs anywhere in the "Car" column (see the example). I want to count cars "not started" as a data point. Unfortunately...

Hello! I need to look up an article number in a table and return a text associated with this number. A pretty easy task it seems, BUT I can't get it right! The workbook has two sheets I recieve article numbers from one program with some content I past this content in "Materiallista". In...

Hello Friends, I have a workbook and there is 6 question and i'm really confused abouth than so if anyone can help to ans those question I will very helpfull and appreciate your help. File Link Thank you.

Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...