countif

Hello, I am getting the aforementioned error with my code, and I have absolutely no clue why. Any help would be appreciated I'm clearly not understanding something. [CODE=vba]Sub MonthlyAdd() Dim Category(7 To 10) As Variant Dim Ar As Variant Dim Br As Variant Dim Catgry As String Dim i As...

Please see below example table. Column A has random numbers between 1 to 100 Column B has the following formula copied down starting from B2: =IF(COUNTIF($A$2:A2,A2)=1,1,0) I would like to get value of 1 in column B if the row in column A is distinct, else 0. This works well only for small...

I have a fairly extensive Select Case statement to translate data. What I am trying to do for Case 20 is count how many cells in the adjacent 7 columns are >0. Basically, I am trying to count how many days someone is scheduled to work based on how many hours they are scheduled that day...

Hi, I'm trying to use multiple COUNTIF to check two sets of criteria. I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria If duplicate IDs are found and the same fruit on both days it...

In A column I have data from 1 to 100, in B column I have "Yes" or "No". In C1 I want a formula total of "yes" from Serial (1 to 30) + (41 to 60) + (91 to 100), Similarly in D1 total of "yes" from Serial (31 to 40) + (61 to 90) what should be the formula ...

Hello, I am trying to look up and return all invoice #'s that were paid in the year 2021. The invoice #'s and year paid are two separate columns. I would like to return all the applicable invoice #'s in column A in another sheet. I have attempted the problem myself using the INDEX function but...

Good morning! I am struggling with a formula and have been so for days so am finally admitting defeat and reaching out. I could use some help figuring out how to combine sumproduct with more than one countif in a situation where I need to count the number of times any value within a list is...

On a long list, I'm trying to count only cells that are higher than the cell above it. (making a formula for every cell (B1>A1) wouldn't work). On a 'Daily sales' list, I would like to see how many days the sales increased compared to the day before. Same goes the opposite way, I would like to...

I have a Google Sheets workbook with 2 worksheets. (I suspect the solution is the same for Excel or Google Sheets, and if need be, I can switch to Excel) Sheet 1 lists about 1000 items (components). The list could grow. Sheet 2 lists some products (200 or so at the moment, but the list could...

I have 3 cells with numbers E20 is 5, F20 is 2 and Y20 is 3. In cell Z20: =IF(Y20>F20,IF(Y20<E20,1,"")) gives me 1 However, =COUNTIFS(Y20,">F20",Y20,"<E20") gives me 0 I can't figure out what happened. I have checked using isnumber() that all values are in fact numbers. I need to use...

Hello, my 2nd post here and I'm pulling hair on another stuck Excel sheet. I've got an Excel sheet prepared however just couldn't upload it here. Actually just one question however with several conditions so I'm putting them into bullet points numbered below: 1. For each document, how do I...

Good afternoon all. We are trying to count and sum the monthly payroll for all employees #1,#2, etc. up to a certain count (in the example below, 7). Essentially, we need all the Boolean answers (see formula) to be in a sequence and then for an array formula to spit out a sum (and count...

I am struggling to find any way to insert a column into the MAIN tab pulling from the INV tab. The MAIN tab is one sales order for 1 customer with 29 rows, intentionally order qty of 1 in each. The INV Tab is the list of invoices for the same sales order. Some of the invoices were for...

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

Hi I have a master data spreadsheet that contains multiple columns including one with the name of a resource. generally most of the cells in this column contain only one name. however some of the cells contain 2 names for example "Joe Blogs / Jane Blogs". they all contain the same format. on...

What does it means R[-5]C[-1]:R[5776]C[-1] in this formula, does it refer to an exactly column? or a row? I dont understand, please if someone could help. Thanks in advantage. ActiveCell.FormulaR1C1 = _ "=COUNTIF('1306-2606'!R[-5]C[-1]:R[5776]C[-1],'Stock Productos'!RC[-6])"...

Hi Everyone! My goal is create a column called "Counter" which keeps track of the number of times OBX appears in another column called "Segment_String" Segment_String Counter OBX123123 1 OBX214313 2 NULL 2 NULL 2 OBX123443 3 NULL 3 NULL 3 NULL 3 Your help would be...

I am trying to separate a string from it's three initial characters. Example: 100345-123-2455 100 345-123-2455 345-123-544444 345 123-544444 I have figured out, with help, how to separate the three characters, using the function...

need a formula to count number of times a value is between 2 ranges. But if the range numbers are equal then do not count data in sheet data25 looks like this Date/Time (col A) First Detected Speed (Col B) Last Detected Speed (Col C) 4/1/2021 0:40 35 35 4/1/2021 0:41 40 10 4/1/2021 0:42...

I'm trying to write a formula that will count the number of rows that contain "Yes" or "No" in multiple columns. However, if more than one column for the same row contains "Yes" or "No" I only want the row to be counted once. Here's what I've tried: =SUM(ISNUMBER(MATCH(Data!$AQ$3:$AQ$1000...