#countif

i have a column in a table which is using a formula to calculate a percentage , i used this formula =COUNTIF(Table1[%],"<5%") but it returned the wrong number and i have no idea why

I have this code to count the number of letter "R" in any given row, see test file below, these two rows contain 2x "R" but my code is spitting out 3 every time... why is that? code below: Dim ws1 As Worksheet Dim lrNew As Long, n As Long, n1 As Long, n2 As Long, sr As Long Set ws1...

Hi All! I'm currently trying to find a way to count how many data "high" in each month. Example: I want to count how many "high" data only in month 1, and how many "Low" in month 4. I've tried =COUNTIF(VLOOKUP(A2,A2:B18,2,0),"HIGH") but it doesn't work. Does anyone know how to obtain these...

I have a date/time stamp column that is formatted as (ddmmyyyy hh:mm:ss AM/PM). The big picture is that I am trying to convert this data so that it can be counted and plotted. Where I am stuck is after reformatting this field into only the military hour, I cannot copy and paste that value into...

I struggle with CountIf functions. I know this should be pretty straight forward, but I can't wrap my mind around it. Below is how the spreadsheet is set up. Don't worry about the conditional formatting of the cells or colors of the dates below. Just for visual. But I want each cell to auto...

Hi I am new to the site and hoping someone may be able to rescue my school data tracking spreadsheet project from certain death! Basically I have created a spreadsheet which in relevance to this formula matches a class code i.e. 7ABC (B4) which is entered on a Y7 overview sheet, with any...

Hey guys, Just joined this forum yesterday and its great. Thanks for the help so far. Could someone please help me figure out how to use COUNTIF for counting the amount of times a repair was done to a certain part #, There are 2 spreadsheets-one has all the part numbers and the other has the...