countifs

Hello together, please help me to extend my VBA code to highlight amount of cells (top to bottom) for a certain year based on how many tools are planned in separate table on the right side in attached "example". So far i wrote code that only counts tools for first country, but i dont know how...

Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...

Hi there, I am trying to automate a meeting planner. I have meetings down the rows, employee participants and time of meetings along the columns and market with "x" in the cells. I would now like excel to automatically populate a new "calendar overview"-table with the times down the rows...

Hello! I am looking to complete a formula that will look for a specific text between columns and rows but only count them if they are between 2 dates. For example, if the text apple is listen between E:N between dates 3/21-3/31 in sheet 1 then deliver a count value in A1 sheet 2. I have tried...

Hi all, I am trying to find the way to obtain the minimum value from a range, with some conditions. So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...

Hi All. I have gone round and round and still have no luck in resolving this, so any help will be much appreciated. I have a list of items that have a status, (open, Closed, In progress). This is column C. There is also another column (E) which has a date (Short form DD,MM,YYY) which hs the...

I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...

I have this formula working on an older version of this report: COUNTIFS(Transactions[Year],B$2,Transactions[Mo No],"<="&MONTH(B$3&" 1")). I have copied and pasted it into a new but similar project: COUNTIFS(Table1[Year],C$3,Table1[Month],"<="&MONTH(C$4&"1")) I am getting back a 0 result...

Two parts to this query: 1) I've written the following code to address each row within range (F15:F44), aka table "WellList[ERP Group ID Number]". It works, but it's rather ridiculous and repetitive. I'm looking for something more concise/elegant which will still allow the user to drag the...

Hello, I'm having some trouble with counting cells using two exclusions: "x" or BLANK. I'm running my test against two tables: One without and one with formulas. The one without formulas produces the correct number (C25), but the one with formulas (G25) is counting the BLANK cells when it...

I've got a table where I need to count a number of cells that are numbers. The numbers are returned by formulas and it might be any number of years as well as text headings. I tried something like =SUMPRODUCT((1:1)*ISNUMBER(1:1)) But it does not work.

Hi I have this code which isn't working; For Each c In Sheets("Support").Range("B2:B13") c.Value = (Application.WorksheetFunction.Sum(Application.CountIfs(Worksheets("Data").Range("G:G"), Array("6", "7"), Month(Worksheets("Data").Range("B:B")), Month(c.Offset(, -1).Value))) -...

Hi and good afternoon, I am struggling to get a formula for countifs to work and i beleive this is due to my criteria ranges not being of the same size. Is there any work around to this? i have put my example below but the actual data set is much larger but i have the same problem. the data set...

Hi, so I have an excel sheet here that needs the CountIFS Formula. I am not sure why it isn't working and there doesn't seem to be anything wrong with the formula but it keeps returning zero. I have tried removing the dropdown list and the data validation but it is still returning zero. Any...

I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...

Hiya all, I'm struggling a bit with I have a list of customers who bought Product A (which is a sample of the main product) on one sheet, then I have a list of customers who bought Product B (which is the main product) on another sheet. Is there a way that I can (on a separate summary sheet)...

i have this table: 2022-101 101 1 2022-pzl 101 1 2020-201 102 1 2020-202 103 1 1 101 102 103 i want to conditional format Row 6 if the matching value in column b (ex. 101) is populated in column c and d even if on different rows. (ie: 101 yes,102 no, 103 yes). i have...

Hi everyone, I'm trying to count the amount of times 2 different cells have the same date and also the times in a 3rd cell need to match and the 4th cell need to be before/after a certain time. In my formula I've only managed to put in the times, so if the date is incorrect it will be counted...

I am trying (without success) to use either Countifs or Sumproduct to count how many cancellations were made with less than 48 hours notice. So, here Status = Cancelled and Start Date >= 01/11/2022 and Start Date <= 30/11/22 AND where the difference in start date and start time and cancellation...

Hi, I have this matrix: A B C 5 5 6 1 3 5 4 2 6 1 5 6 and I would like to count the number of "1", "2", ecc for each column: A B C 1 2 0 0 1+2 2 1 0 4 1 0 0 6 0 0 3 So a kind of countifs where you can set "A" and "1" as parameters. Any suggestion? :)...