countif formula

Hi, This is the first time I've posted here so apologies if any of this is incorrect. I have a list of products ordered by week with their volume. I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by...

I am trying to modify my countif statement. I like to enter a start(a1) and end date(b2) to have my formula filter and count only the date range. is this possible? any help would be appreciated. =COUNTIFS(E2:E100,"Apples",G2:G100, "Accepted")

in cell O45 I have a countif formula The formula is looking at the cell range O7:O11 and counting yes,no, n/a appear. I then want to conver the result of the countif from a number to a text value using this logic: If the "no" count is zero, return "yes" If the "no" count is 1-5, return...

I am trying to make a dynamic frequency table in VBA using the countif formula. The general idea is to: 1) find the highest and lowest values in arange using "max" and "min" formula. 2) Create 30 intervals using interval (max-min)/30...

I am working with a very large data set where I need to be able to count the number of individuals for a particular position based on either their hired date or termed date. With smaller data sets, I can just sort by hired or termed date, then position, and manually count by selecting the...

Looking for a way to count the number of unique values. Note that some cells have multiple entries. Need to ignore the text and dates and just count the number of “numbers” even though they themselves are in a text field. So for the example below, the number of unique values is 12. Note: need to...

Hi There I'm trying to write a formula so that if "Red" appears in the A Column, I need to count how many times "Yes" appears in the D Column: <colgroup><col span="4"><col></colgroup><tbody> A B C D Open/Closed? 1 Red yes 2 Yellow yes 3 Yellow yes 4 Red no...

Hi, I have a question I hope somebody can help me with. How do I setup a COUNTIF function so that it 'searches/uses' more than one column for results. Example: I have a spreadsheet with 20 columns - starting at A1 to T1 - and ending at A100 toT100. I want to use the COUNTIF function to...

is there such a way to write a formula to count the number that are within 10% of a particular number or a number in a cell? thanks in advance

Im working on a spreadsheet where I need to count the occurrences of a specific number in a column (Example) A 0 1 0 0 2 0 As I filter other columns I want to be able to know how many 0's, how many 1's and how many 2's (not including the hidden or blank ones). I know I can't...