countifs

I'm trying to count the number of shifts of employees by looking up by employee. The shift data is on a seperate worksheet. I would like to use a formula that refers to the cell for each employee and then finds the corresponding name and counts the number of shifts in the rows and columns on...

I have 3 cells with numbers E20 is 5, F20 is 2 and Y20 is 3. In cell Z20: =IF(Y20>F20,IF(Y20<E20,1,"")) gives me 1 However, =COUNTIFS(Y20,">F20",Y20,"<E20") gives me 0 I can't figure out what happened. I have checked using isnumber() that all values are in fact numbers. I need to use...

Hello, I am trying to use COUNTIFS and INDIRECT but my formula is not working. I have different sheets, and each sheet represents a store location. In each sheet, there is a Sales Person name and the sales amount generated for each store item (e.g., shoes, tops, dresses). In my summary sheet...

Hard to explain from the title alone. What I would like to be able to do is calculate the number of (days or weeks) a specific project has had a specific health score, before it changes. Assume that the sheet has many many date ranges and there will be a new column added each week with a new...

I am trying to use countifs function in google sheets to count colored cells in one column, but only if the colored cell meets the value I set in a separate column in the same row. In my head, the formula would be something like: =Countifs(I:I, "Tuesday", P:P, "light green") I am already using...

Hi, Hoping someone can help - I'm trying to add an additional condition to the below formula to check whether the value exists in another (dynamic) range, however the best I seem to be able to get is that it compares value 1 with value 1 and value 2 with value 2. For clarity, "main_data" is...

Hello, my 2nd post here and I'm pulling hair on another stuck Excel sheet. I've got an Excel sheet prepared however just couldn't upload it here. Actually just one question however with several conditions so I'm putting them into bullet points numbered below: 1. For each document, how do I...

Good afternoon all. We are trying to count and sum the monthly payroll for all employees #1,#2, etc. up to a certain count (in the example below, 7). Essentially, we need all the Boolean answers (see formula) to be in a sequence and then for an array formula to spit out a sum (and count...

Hi, I am attempting to use two countif conditions across multiple sheets (which I have named "Tabs" in name manager) to count how many times a job is raised for an item with a certain reference number in a particular year of its ownership. I have used a no. of forum posts to get me to where I...

Hi, I'm trying to count multiple occurrences of words in a cell. Essentially, I would like to count the occurrence of the following words: apple, orange, banana, strawberry so that for the data in the below table I get the following values Data Count of words apple, orange, tree, butter...

Hi! I have the formula COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");"A*") but instead of A* (to say that it should select the values that start with that) I want to put a cell (f4) which says A. How can I do that? Thank you very much

Hi, Can I count the first instance of a duplicate value with multiple criteria? Based on below table we have the following: - 3 unique companies - 3 unique PO's - 12 items across 3 PO's Based on below table I want the following: - Cell B2: This cell should reflect the amount of PO...

Hi all, Hoping for some help with a formula please. I have an averageifs formula that works fine looking for an average with two criteria. My issue is I only want this function to work if a name appears more than 2 times for everything else I just want it to be blank. I have uploaded an...

Hi! I am trying to find the oldest date in KPI!$G:$G meeting all the conditions of either these two formulas (I obtained the same result) -...

Hello! I have below table with dummy data and what I need is to: - Choose multiple selections from the drop down list without a VBA, is there any trick for that? if not what is the suitable VBA code/macro that you suggest - When I choose multiple selections, what should I update in my current...

Hi, I want to write a formula that computes the normalised Gibbs entropy, which is computed as follows: The values that I want to test this for are located in column Z, AD, AH, AL, AP, AT, AX, ..... CL etc. so 3 columns are skipped every time. I want to test for values 0 - 10. I already...

My Google sheet can be referenced here. On the 2021 Openers tab, I need to create a formula that will allow me to count the total amount of leads associated with a specific person within a specific month, referencing the data on the 2021 Lead Data tab. Formula criteria to consider: The Leads...

Hi all, Having trouble with a CountIfs function. I am trying to answer the question: At any given time (down to the second), how many people were in attendance at our online course? My spreadsheet looks like this: A B C D E F SessionStart SessionEnd Concurrent Viewers 7:00:00 PM...

I just can’t crack this one. Can anyone give a hint in the right direction, please? I have this one sheet (Daily presens) where all of the leaders for each departement enters if the staff is pressent. Then I have another sheet (qualifications) that contains all the certifications each worker...

Hi, I need a formula to calculate a total number of incidents that are 1) active status and 2) raised by the target users. I have shown a small example in below image. Thank you in advance Regards,