countif 2 conditions met

Hi, I am looking to work out if a list of items have been Completed, Due or Overdue. For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days. For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days. For Overdue, it should be overdue by: 24h 48h 72h, 5 days...

We have a register keeping track of all our counselling referrals and I need to keep track of numbers of unallocated patients based on differing sets of criteria, as below: <tbody> First name Surname Funding Counsellor/status Angus Smith Bolton Franklin Beaumont Smith Hitchcock...

I'm trying to count the instances value are less than zero given two dynamic column ranges match. That's a mouthful. These are named ranges 'universe' and 'planets'. I have the following formula to give me the total number of instances that I have a match however I'm not sure where to include...

Hi All, I am looking to combined these two countif statements below to get a new =countif(Statement1 AND Statement2), I can't seem to figure out a formula that will work.. is this possible? Or is there a better way to do this? Statement 1 =COUNTIFS('Paste Key Survey Results'!F:F, "Yes")...

I'm pretty sure I'll have to use an array formula for this but here is what I need 4 dates in Columns H, L, M, N I need to find the MAX date from each column's row Example: =MAX(H5,L5,M5,N5) But I need to do this for ALL Rows then COUNTIF that Max Date is greater than today's date +30...

Hello, I have one column where i am tracking all my deals for number of days since online Column A # of days 8 15 4 2 0 -1 and so on so forth I would like to count all my deals that are older that 8 and above. as you can see there are two deals that are equal to or older than 8 days

Hello I am trying to clean up a table to crosscheck some values where it is wrong. I am trying to write a formula that will capture all that I need. I have attempted the Countif function, but was unsuccessful. Here is what I am trying to do. <tbody> Account Name Taxation Status John & Jill...

S No Name Vehicle Having Date of Joining Experience 1 Kane 2 18-Nov-02 12 Years 10 Months 2 Morris 3 18-Nov-02 12 Years 10 Months 3 Bill 1 3-Feb-03 12 Years 08 Months 4 James 2 17-Mar-03 12 Years 06 Months 5 Rohit 1...

Hi guys, Trying to develop an array formula that can handle two ranges and result in a simple count. At present my data is split between two cells, one of which is a $ amount, the other is a date (as seen below). <colgroup><col style="text-align: center;"><col style="text-align...

COUNTIF(INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"<>NA") the above is my equation now. i cant figure out how to say not equal to either "na" or "blank." right now this answer obviously includes instances of "blank" as part of the count. this is part of a larger equation where i am...

Good morning! I have a issue using countifs. I have a column of data that contains 3 characters - I, M and B. I want to only count I and M. I am currently using {=COUNTIFS(Paste!P:P,"I",Paste!P:P,"M ")} without {} but I only get 0 as the result. Paste is the worksheet that the data is on and P...

<tbody> <tbody> Contract # Unique Id Vendor Name Business Unit Real/Assigned CW ID Custom Unique ID Sent To Legal CW1 268 Vendor 1 Sales Real Vendor 1 CW1 268 Yes CW2 5453 Vendor 2 Ops Not Available Vendor 2 CW 2 No CW1 89374 Vendor 1 Ops Not Available Vendor 1 CW 1 89374 Yes CW4 5675...

Hello, Please advise me as I am just learning how to use these functions. I am trying to use a formula that counts unique text values from this range:(Patient_level!C6:C15000) while meeting certain criteria ('yes') in this range: Patient_level!I6:I1048576. I have working formulas for both...

Hi everyone, In an employee list, I am trying to count all leavers in a month based on their position. So far I have: =SUMPRODUCT((P4:P719>='startdate')*(P4:P719<='enddate)) which counts all leavers and works like a charm... but I can't get it to count only the leavers with position "SM"...

So i am trying to make a list that will ultimately be used to keep track of data from 5 different locations. I have generated the data fields and made a reports / totals page and all of that works so far. I am doing this for a tournament and need to divide up the competitors. there is a tab i...

Hello Everyone. How can I put these two formulas together? =COUNTIF(B8:B4000,"<"&(TODAY()-180))+COUNTIF(G8:G4000,"=Y") Basically the above formula is counting the total cells that are over 180 days long plus the total cells that include Y. What I need is to count only cells that include a Y...

OK what I have is a list of names in this format: Mendenhall, John LPN, in A2 thru A70. In cell B2:B70 I have numbers with and without a letter example: 6p, 6d, 12p, 12d, D, ML, AL etc and the word "noon". What I want to do is countif the last letter in the name column A2:A70 has an "N" and if...

I am working with a very large data set where I need to be able to count the number of individuals for a particular position based on either their hired date or termed date. With smaller data sets, I can just sort by hired or termed date, then position, and manually count by selecting the...

Hello, Column S contains different strings of text. Column E contains the date that the information in Column S was decided. I would like to be able to calculate the following two things: Count the number of times the phrase "not eligible" appears in Column S IF the date in Column E is in...

Here is the scenario: Content: - Column B: 8 digit "numbers" but formatted as text to allow for leading zeros. - Coulmn G: Last Names. - The spreadsheet is constantly being updated. It currently has around 500 lines of data, but will be added to on a daily basis. Description & Objective...