countifs

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,

Hi Everyone, I have an Excel table. I am trying to perform a multi-column data validation. I am trying to use the COUNTIFS function like so: =COUNTIFS([Supplier],C2,[Supplier_Code],D2)<=1 The goal is to ensure that the data entered is not a duplicate. The combination of [Supplier] and...

Hello everyone, I'm not sure what kind of function of is needed here, though here's a sample of the data and what I'm trying to do: Session 1 Startup Arabic Yes mickeymouse@aol.com Turkey Male Syrian Session 2 Startup Arabic Yes mickeymouse@aol.com Turkey Male Syrian Session 4...

I have searched, tired, failed. I am trying to count across multiple cells. For example, A is a name and D is a "problem". I want to see how often a person has that problem and countifs worked great. Now the problems are spread across C:H and it won't work. Is there a better function? In this...

Hi everyone, I am having issues counting the number of Males/Females that were enrolled in a study during the month of March (3/1/20-3/31/20). I'm not sure why, but when I try to use the COUNTIFS formula to figure out the number of females that were enrolled in March (between 3/1/20 and...