count based on range

I am trying to get excel look for a name in one column and then count the number of cells that have a certain word. Currently I am trying: =COUNTIFS($F$1:$P$138,$S$4,$F$1:$P$138,X5) but all I get is a #VALUE. I have tried it as an array formula as well. I don't know why it isn't working...

Hi all, This is my first time posting here after having read a lot of threads, but i'm currently facing something i cannot seem to solve. My situation is as follows: In one worksheet (A) of my Excel file I have a list of entries divided over four columns (A,B,C,D) and 8000 rows. these are...

Hi All, I have a very strange condition where I have to get my answer in a single cell. Note: I do not want to populate any randome cell and refer that in my cell function. See the below table: COLA COLB COLC COLD 123 123 Y 223...

Hey there, I have a list in A2:A10 and I want to count the frequency of total occurances the values in this list (A2:A10) occurs within my larger list that is within B2:B2000. Is there a way to do this with a simple formula, instead of having to do individual counts for my smaller list then...

I have been looking through all the posts and can't find anything that fixes my formula. I have dates in range P5:P88 and some of the cells are blank. I am also trying to bring back the dates, that are equal to today or greater by 30 days based on the values in range F5:F88 Here it is...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING FORMULA IN EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA BELOW. I WANT TO COUNT THE " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN VALUES" FOR EXAMPLE: IT WILL GAVE ME THE FINAL RESULT AS. DISTRICT--> JAMSHORO HAD...

I want to count the number of rows that have a specific number of populated cells. For example looking at the table below, I want to know the number of rows that have "Yes" exactly 2 times. I only care about text though that's in columns C, D, E, and F (A, B, G, and H should not be included in...

Hallo Guys, I am working on analysing data for over 277 sheets with different datas. What I am searching for is to find how many times is this number which is greater or eqaul to a number and less than another number repeated. For example a number : 0<= number <4 I attached example worksheet...

So I have a very simple problem, but when I search on how to do it, it seems the code I have been seeing are longer than it's suppose to be? So here's my problem Everyday Column A generates a different set of numbers. What I need is to count all the cell and input the total on the last cell...

Hello everybody! I'm trying to derive a formula where I count all of the values (duplicates and all) in a column (E), based on another column with dates (B). So I need to have a formula showing all values that fall in today, yesterday, 30 days and so on. I found the formula to get all unique...

Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...

Hello, I am stumped how to write a formula that takes a cell with a value formatted as Date & Time and another cell with a value formatted as Date and Time and returns a result that is the qty of 1/3 days in the period between the two times. Any portion of a third should count as a full third...

is there a way to turn this: (col a) (col b) (col c) (col d) fruit frequency eaten time to eat red color? Apple daily med yes cantaloupe weekly high no cherry monthly low...

The first column in my spreadsheet has four different types of values "yes" , "no" , "see above" & "" (blank values) I would like excel to look at the first column and find values that say "see above". Then I want it to look at the cells above it and copy the first "yes" or "no" that it finds...

Hi, I'm trying to specify a range for count if based on the value of a cell - if this is possible (i cant work it out using either type of cell reference), if not i'm looking for a way of doing this? ie. cell E7 currently has =IF(COUNTIF(E3:E6,"No")>0,"No","Yes") but i would like the range...

I am trying to solve an issue which I am struggling with greatly, and any help on it would be very much appreciated. I will try to break the issue out into steps in hope that it might be helpful. I have sheet1 that already contains information and sheet2 with information that I want to insert...

I have a gradebook that contains 3 assignments. For each assignment, a student could choose between one of three options (A, B, or C). Some students completed multiple option. <tbody> 1A 1B 1C 2A 2B 2C John 6 3 2 4 6 Mary 2 2 3 Sue 4 </tbody> I need to count how many...