count & count ifs

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,

Hello, What formula can i use to count the number of individuals joining by month and year in column E. I've tried the formula below however get a value of Zero =COUNTIFS($Q$16:$Q$4007,MONTH(6),$S$16:$S$4007,YEAR(2019)) <tbody> a b c d e 1 6 2019 john June 2 6 2019 jacob May 3 5...

Hi ALL!! I've been working on a VBA project on and off for a little while to make things easier at work. to tell you a bit about my work, I'm actually a lab analyst rather than a data analyst, so mostly I'm mucking in testing tap water rather than playing around with excel :laugh:; but each...

I have data similar to below...I would need help in getting coutif formula ...I need count based on names and it should exclude the "Zero" value lines...for each amount type... I need one count for aaaa & bbbb and rest all other names should come under other names.... <colgroup><col><col...

Need help fellow Excellers... Column G has either "A" or "B" placed in each row. Column L has either "X" or "Y" placed in each row. (The values above are internal coding. They could be any value, really) Trying to calculate the percentage of "X's" that appear in column L that are assigned to...