countif function

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

Hey Everyone, This is my first post on the forum and I really need some help! Currently I have an IF function like this: IF(b4=f4,1,0) then a countif(results,"=1") where results is a dynamic named range of the results of the if function. I have to drag down the if formula for the entire...

Okay, so as quickly as I discover the answer to one problem, I create a completely different mountain to climb! As an extension of my last post, I used the Find.Method to find the Header to the column I was looking for. No problem, I have gotten that down. What I can't figure out, is how to...

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

Hi, Been looking through this form and can find a solution to this, so hoping that someone might have one for me. I'm using a COUNTIFS statement with multiple criteria. Use 2 sheets, 1st is call "Master" which has all the data, second is "Reports", which has all the formulas. I'm trying to...

Complete Excel newbie here. I have a workbook consisting of two sheets: a Monthly Class Schedule (Divided into five one-week blocks. Each block's vertical is Mon to Fri, the horizontal is 9 class slots. There are 45 class slots pw). Each class has one student and the cells are filled 'Student...

Hi guys, So I have been stuck on this for hours and I would appreciate the help if anyone can figure it out. I need to find how many times the word "Sedan" appears on a separate worksheet named "Automobiles Purchase Info." There is a column on that worksheet, with multiple vehicle types...

Hey guys, Just looking for a quick bit of help. Looking to use averageif for two conditions. Normally I'd use the averageifs formula, but, it's not two conditions on one value it's one value where it can be A or B. I've even tried the OR function with no success... So, what I've tried to do...

I have a worksheet that is used to log phone calls. We can get several calls from the same person and I would like to identify the dup call. I am doing this with this statement: =IF(COUNTIF(C$2:C$1000,C2)>1,"DUP","") This works well to identify the duplicate callers. My challenge is that...

Hi all, I'm hoping someone here can help me solve this formula if it is at all possible. Here's the short story of the problem: Columns and their representation: Columns A through C represents an overview of data collected. A = Names B = Errors YTD C = Errors MTD Columns D through H are...