conditional count

Hi, I'm trying to create spans and layers and I was able to do that, however, I need to create a new span and layers with condition below: If management chain level 2 = Manager C or Manager G or Manager J, then exclude the count, do you have any suggestions for suitable formula? the current...

Hello everyone, I am using Excel 2007 on Windows 10 and have some troubles with counting in excel. I will explain it in example: DATE 1ST 2ND SHIPMENT 01.01.2020 Apple Banana yes 01.02.2020 Banana Apple yes 01.03.2020 Orange Banana no 01.04.2020 Apple Orange no 01.05.2020 Apple Orange yes...

Hi, I have a list of Account User IDs (Column 1) and a list of email addresses(column 2) associated with that user. I need to count the number of unique email addresses per user and display this on each row (column 3). The data I have is stored in tables so I need the formula to allow for...

I want to count 'a' (absent) of each employee listed in column C to D for each particular month as shown in the table Column G thru H. Please suggest a formula to achieve it. The Screenshot below will better explain what I'd like to do. Thank you in advance for your help

hi, I have column A containing values of 1 amongst blank cells and I’m looking for a formula to sum up the cells containing “1” between any given 2 blank cells, displayed in Col B. Does anyone have any suggestions? Example below; <tbody> col A col B 1 1 1 3 1 1...

Hello Mr. Excel! I have a fairly large data set that i'm working with and I am trying to determine the number of unique combinations given a certain criteria. I have 3 fields i'm trying to compare, Active ("Y" or "N"), Customer Name (there are many different names), Project (there are many...

This is for a school. I need to rank the students based on family information. FamilyID = one ID per family StudentID = unique student ID Grade = student's grade TeachingFamily = binary, do they have a parent who teaches at the school Status = are they a Full Time or Part Time? (not binary, as...

Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...