countif multiple criteria

Hi, I have below list and need help with adjusting the current formulas to meet the logic below: "if any employee received merit or promotion before official date, or received promotion on official date, or merit transaction and increase % is more than budget %, then R, otherwise NR". Another...

Hello, I am trying to rank my items in the below table in excel 2003 so I can't use countifs. I want to rank the items by quarter (Column E), then by month (Column F), then by material and size. the below formula I am using works for 2 criteria but I need to add 2 more. Formula that works for 2...

Excel 2007 <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead> A B C D E F G H I J L M </thead><tbody> 1 Name Alewife - Alosa pseudoharengus American Eel - Anguliia rostrata Banded Darter - Etheostoma zonale Banded...

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

Hi all, In the sample data below, I need to find the number of unique codes in column A coresponding to "M" in column B. Is there a simple formula I can use? I'm using Excel 2010 if that changes anything. A B 1 1233 M 2 4562 M 3 1233 M 4 7625 S 5 7352 S 6 4562 M 7 2447 S Thanks!

I'm trying to do something with excel and I'm not quite sure it's possible. I have data on a spread sheet ranging from 1:15 One step I have taken in what I want to do is having a formula to count the number of time a certain data input shows up: =COUNTIFS('spread sheet'!1:15,"data 1") But...

Hi, I have the following formulas in each of the cells under the column entitled "Case #s used for category": =COUNTIFS('Case 1'!$B$1,"=1",'Case 1'!$B$2,"=A") =COUNTIFS('Case 1'!$B$1,"=1",'Case 1'!$B$2,"=P") =COUNTIFS('Case 1'!$B$1,"=1",'Case 1'!$B$2,"=TB") =COUNTIFS('Case...

Hi. I apologise if this is a really simple question but this has been bugging me for a while now so I am having to ask for some help please. I am using Excel2003 the image below is only a part of my spreadsheet. I have tried to keep it to a minimum. The below is on sheet1, on sheet 2 i am...

Hey guys, I am trying to motivate myself in anyway possible, I figured by creating an excel sheet and seeing some statistics might help, worth a shot. I would post a screen shot but it is way too hard. Anyways, I have a tab for data where I have a column with each date for the remainder of the...

I have Excel 2007, using a Table called sawmillTable I am looking for the count of days the machine ran. There are multiple days because of breaking down dimensions, specie, etc. So I need to ignore duplicates in the [date] field, I think. If someone could help get me started that would be...

Does anyone want to have a crack at this one?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have 4 Worksheets of Data<o:p></o:p> <o:p> </o:p> In each of the 4 Worksheet Column “A” Contains a Product Code (e.g. Cell A3=”XXXX”)<o:p></o:p>...

Hello! I need to use a named range of words ("wordlist"): red green blue etc... And I need to search for ANY cell in another sheet that may contain any of these words (at the beginning, middle, or end of a string), and highlight that cell in red. I'm using Excel 2010, and I can't get my...

Hi, I'm having a mental block that I'm hoping that someone can help with... I have a column containing number of days to resolve a certain issue. What I'm looking to do is produce a summary tab to show the number within certain ranges (i.e. how many took between 1-10 days, 11-20 days, 21-30...

Hi all I'm trying to setup a countif formula, but I want it only count if it's a unique match in the previous column... for example: column A is used for category; and column B is what I want to count, but I would like it say: only 1 B for C1; Only 1 C for C1; Only 1 C for C2... etc (i've...

i using following formula but it returns no results COUNTIFS($O:$O,S16,$B:$B,R16,$P:$P,$T$15) O:O, is list of names S16, is specific name B:B, is Items list R16, is specific item P:P, is only month (mmm) derived from a date column (dd/mm/yy) T15, is month [Jan, Feb, Mar,......Dec] i think i...

I am trying to get a count of the number of rows in a worksheet that meet the following conditions: 1. Date in a specified cell is greater than today's date - ie: (BD$35<TODAY())<TODAY()< font> 2. A specifed range of rows contains the word/characters TBD - ie: =--ISANUMBER(SEARCH(“TBD”...

Hi, I worked out a solution to an issue i've had with an exel spreadsheet using the COUNTIFS, however when i've got to work we don't have excel 2007 and i've realised now that there is no COUNTIFS function in '03 Is there an add in that can be added to excel 03 or a function that can be...

Hi all. I would really appreciate some guidance here. Using formula rather than VB, I would like to calculate the number of blank cells that appear in a column BEFORE the first active cell but exclude any blank cells that appear after the first active cell. To elaborate, I have sheets that...

Hello, My hospital in South Georgia - US - chages .97 cents per medical record page from 1 -20 .83 cents per medical record over 21 pages to 100 pages .66 cents per medical record page for anything over 101+ What I'm trying to figure out is an formulea for placing one number (page amount)...

I am working with two different a data about properties, and I am trying to count: -the number of cells in an array in that match a given criteria -and of those cells, how many match a criteria for a 2nd array in the data set Array 1 (size): 70,000 | 52,000 | 60,000 | 30,000 | 75,000 | 25,000...