countif 2 conditions met

Hi, I have a large dataset made of orders (duplicate order id in column A for orders containing multiple items). I need to calculate total price of order based on unit price/item. I have tried to sumif(take(filter but it doesn't work. Same for a countifs based on multiple criteria located in...

HI, I have a large table, and I'm trying to count the closed, in progress, resolved, and closed statuses. I have multiple assignment groups, and I would like to count the volume of each assignment group. There are multiple rows for the same assignment group as well. I can't use a simple count...

I know this has been asked a number of ways and I feel I have got myself so convoluted with so much information I cannot make heads or tails out of how I need to write this formula I have a spreadsheet Suppl Name PO Supplier A 41058 Supplier A 41099 Supplier A 41099 Supplier A 41166...

Hi Wonderful people, Trying to get a countifs formulae to work based on the below: COUNTIF first column = Text (got this solved) COUNTIFS second column = yesterday (today - 1) I tried the below, but to no avail Countifs(A:A,"first interview booked,B:B,TODAY()-1 Also tried it with the...

Basically i need to count evrything under 5% in column h then if its green on column i i need th minus of exclude the count, the correct figure should be 18...

Hi Everyone! I am trying to create a spreadsheet to better track equipment as well as personnel at work. The basic idea is managers at different sites submit daily a check list at that info is added to a sheet similar to my sample...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

Hello excel gurus, I have googled long and far and wasn't able to find the solution to this basic problem. I am trying to COUNTIF a range is greater than (-1,000,000). I noticed the number it was resulting in was too high. I have a lot of zeros in the table, which seem to qualify for that...

Hi, looking to get help for this issue I have that I can't figure out. I'm a newbie on Excel formulas So I have columns that need to yield 1 or blank based on separate columns that are in-between texts. The requirements are; IF Column's A, C, E, G, L, N (number columns) has one entry that...

I have an order form that contains a load of products- product 1, 2, 3, 4 etc. I have the names of the orders that they appear on and the date that the order is expected. On a separate sheet all the orders are in a big long list. I need a formula that looks at the product name, ensures it is on...

Hi All, I am creating a backtesting spreadsheet and I am trying to work out a formula. I have a column [Column Q] that I can input (D, 4hr, 1hr) timeframes into. I am trying to work out for the "D" eg. Daily timeframe, what percentage of them were Wining trades. I also have a column [Column W]...

I am about to throw this computer through a wall. I cannot get this formula to work. It's a simple COUNTIFS if a certain number appears in a context between two dates. A120 = 07/01/21 A121 = 07/31/21 Transfer is the column with the phone numbers Call_Date is the column of the date of the phone...

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

Hello I am really hoping someone on here can help, I am a bit of an excel/gsheet newbie... I am trying to create a TOTAL of actions overdue depending on the date. I have managed to use the COUNTIF function to count the dates that are overdue in column H. The next step is where I am stuck...

I am looking for a way to count unique values in column E based on column M = "Installer/contractor" AND column O = {"A1";"A2";"A3";"B1"B2"} Currently my formula is: (it only includes column M) =SUM(--(FREQUENCY(IF('Visit Data'!$M:$M="Installer/Contractor";MATCH('Visit Data'!$E:$E;'Visit...

Hello all, nice to join this community :) I have a question regarding the countif function in VBA form. The actual situation I have a master workbook(Wb) with a user form - file explorer (Screenshot 1) and a Sheet2 for the results(Screenshot 2) I have a source workbook, which has a huge...

I NEED THIS FORMULA TO BE SIMPLIFIED BECAUSE IT TAKES A LOT OF TIME FOR EXCEL TO COMPUTE IT Simple background, I need to count all the cells containing "OT 1","OT 2","OT 3","OT 4","OT 5","OT 6" from 7 columns (PROC1-7) , but only for a specific date (represented by A5)...

I am getting #VALUE error the below COUNTIFS formula, tried various possible changes based on research, but nothing works =COUNTIFS($G$2:$G$2184,02.11.2019,$I$1:$I$2184,Resolved) Both conditions work when used independently

I'm looking for a formula to count distinct values in column E (Order Numbers) if they are on a specific date in column M and if the orders are complete, or have zero left to build, meaning column R values are equal to zero. I've used...