count & count ifs

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

Hello Everyone, I have a following Data set Batch Invoice No. BT-1 ABC/01/2020-21 BT-1 ABC/02/2020-21 BT-1 ABC/03/2020-21 BT-1 ABC/04/2020-21 BT-1 ABC/05/2020-21 BT-1 ABC/06/2020-21 BT-1 ABC/07/2020-21 BT-1 ABC/08/2020-21 BT-2 ABC/11/2020-21 BT-2 ABC/12/2020-21 BT-2...

Hello, Thank you for your help in advance. I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below. I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to...

I have a table set that I can't sort or adjust. I want to count the number of matches in group 2 based off of group 1. In this example it would be 3. Group 1 has 3 that match group 2, APPLE, ORANGE, PEAR.... MIKE doesn't match. What formula would do this? 1 APPLE 2 corn 1 ORANGE 2...

Hi I am trying to track the reliability of vehicles within our fleet, every rota we complete an evaluation of the vehicles where they will be tested on various criteria and scored as a pass or fail (with a fail marking a 1 on an excel table). This data would be better understood by our...

i did this formula but i dont know why its not working its suppose to count the rows where the status is if done and the date should be from the last 7 days including today can anyone help me =countifs(table1[status],”done”,table1[date],”<=“&today()-7) for some reason it counts all the dates

I would like to create a formula for each customer (column A; i.e. customer 1 made 8 purchases, customer 2 made 20 purchases, etc...) to calculate how many times they have bought a specific brand (column K; i.e. cell V8 shows that customer 1 bought 6 times brand 2). I have created a formula in...

I have Three worksheets, and essentially I want to select a cell in Column A of Sheet 2 (As the Active Cell) and check if there are any duplicates in Column A of Sheet 3 (The Range for this Sheet should be from A1 to the last row of Data). If there are any duplicates, I would like a msgbox to...

Hello, I need assistance on what should be a simple task. I am currently setting up Power BI for our business where as previously they have been using IBM Cognos, or just straight Excel file outputs with lots of tables of countifs and sumifs, etc. The most complex they had were pivot tables in...

Hi I'm hoping for some help to create some stats on the status of working through client jobs. First I must state that I can't use a pivot table or Visual Basic solution as there is a shared workbook which I don't control. I've simplified client on boarding in an example. I was wondering if...

Hello, I am using the formula below to count the number of incidents in the month of January =SUMPRODUCT(1*(MONTH('Data Sheet'!$P$2:$P$1009)=1)) There are only about 30, but it is returning 900. It seems to be counting blanks as January. Is there a way blank cells can be ignored? Thank you,

I'm looking to make our schedulers lives easier by creating a chart based for giving out over time to our front line employees. we do so by email bid. and email goes out a week prior with available dates and shifts. employees then respond what dates they want to work. they are then selected...

Hi, i'm a newbie in need of urgent help. I have a data set that records meeting occurrences. The start time and end time of the meeting are in a cell each (Rows I and J in the attached image). I am trying to count meeting occurrences looking at half hour intervals. For example if a meeting...

I'm trying to pull back a count of SLAs for a particular month with the count of "Met". The formula I'm using is: =COUNTIFS(CONTAIN[Closed Month],Month, CONTAIN[SLA],"*Contain*",CONTAIN[Contained 4 Hrs], "Met") I have similar formulas in this Dashboard that work fine that are similar, such...

=IF(ISBLANK(Q22),"FAIL",COUNTif(C27:Q27)"=>"&$Q$22),IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS") I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...

Good day all, this is my first post here. I have a table of information that I edit each day, needing to have the newest information on the top of the list. I need to do a count of non-blank cells in column A, and as I append the list, I add a blank row at the top of the list. Well, I actually...

I have two columns in Excel: <tbody> Column A Column B Res Qty Total Hrs 2 66 1 30 Res over 32: 10 3 93 3 102 5 180 5 155 ... row #57 ... row #57 </tbody> (66/2 = 33, 30/1 = 30, 93/3 = 31, 102/3 = 34, 180/5 = 36, 155/5 = 31) > 32 count = 10 Question: I want...

Good morning, I'm using the following formula: = DATA! $ BL $ 2: $ BL $ 995, "Alex", DATA! $ E $ 2: $ E $ 995, "MTM50) which is working perfectly, but I need to add a date criterion, which only counts the cells that are common to: "JULY", "ALEX" and MTM50 (machine). in other words, I want...

Hello everyone. I need help figuring out how to repeat a procedure I created. Here’s the code: Sub osvPrint() Dim osv As Worksheet Dim vosv As Worksheet Set osv = Sheets("OSV") Set vosv = Sheets("vosv") vosv.Shapes("Textbox 5").TextFrame.Characters.Text = osv.Range("D5")...

Hi, i am trying to use a sumif formula to identify where a customer name (column A) is a duplicate and the value in column AY is + or - 10% of the value in the duplicate line. Is this possible using a sumif? If not would anyone be able to suggest a different solution? Many thanks,