countif 2 conditions met

Hi, I am on an assignment to count the number of rows which contain specific text and print the value on email. However I'm stuck here Here are my code Public Function First()Dim Source As Workbook Dim Var1 As Integer Dim Var10 As Integer Dim Source2 As Workbook Set Source =...

Title may be a little confusing, I apologize. I have expense reports that contain multiple cost codes, job numbers, and expenses. What I want are 3 columns: a list of cost codes, a list of job numbers, and a $ total. I also want this list to e self propagating, meaning that I do not have to edit...

Hi, i want to count with two different conditions. For an example i have a sheet which contain my daily report with complete date and what i have made that day. like pen, pencil, rubber etc. i want to count that how many pen for a particular day i have made? can any one please help me!:(

I know there are many messages floating for "Countif". But i have a rare issue This below is a format which i query from a webpage, in which the initials comes in the second line. I have 2 guys with the same name but the initials are different. No I need to Query how many "medium" tickets...

We are trying to count the number of leads (segmented by Lead Score) that came in through our internet forms overnight that the call center will have to respond to on the next morning when the call-center opens. Our call center is open Monday-Thursday (7am-7pm) & Friday (7am-5pm); it is closed...

http://www.mrexcel.com/forum/excel-questions/61648-countif-combined.htmlI have 2 columns of data where I need to count the number of times a value within a range occurs in the same row as a particular value in the second column. I found this post...

I've set up a CountIFs to check how many values were between an initial time and a final time. =COUNTIFS($R$8:$R$10067,"<="&W8,$R$8:$R$10067, ">"&V8) I now have a column which has either +1 or -1. I want to split the value returned from the above CountIFs so that i know how many have +1 or...

Hi, I am trying to count how many times the values appear in column 2, but if the corresponding value in column 1 is a duplicate, I only want to count the value in column 2 once. <tbody> Unit 1 730 Unit 1 730 Unit 2 715 Unit 3 730 Unit 3 730 Unit 4 730 Unit 5 715 Unit 6 715...

Hi all, Here is my problem today. I have a list of joint info that i need to find if they are duplicated joints or are the same joint just cut up. I have the formula for finding the Duplicated Joints just based on the joint info. But now I need to find the ones that are really a different...

Good Afternoon (AEST) Aust, Searching for a formula for the following: Fields A1:A100 are filled with 4 specific dates (one is eg, 01-Aug-12) and Fields B1:B100 filled with YES or NO. I need to conform to Excel 2003, to add the number of "01-Aug-12" if Col B returns a "YES". Tried some of...

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

I'm trying to highlight the topmost cell in a row if any non-blank cell in its column does not match the value of the header cell. The top of each column is the name of an employee. Each row represents a project on which the employee is working. If an employee is working on any projects, his...

I need to work out the number of records in my spreadsheet that are within the past x no of days in column L AND have either "Phone" in column F or "Visit" in column E. These values are displayed on a hidden sheet before being shown in a label on a vb form. I am able to work out the total...

I am creating a financial model where I am trying to calculate the NPV and rNPV of several assets. One of the potential streams of revenue is a one-time 'milestone' payment of $30M if/when the cumulative sales of the product exceeds $500M. I have projected revenues from product sales for years...

Hi Frnds, i am working on the file where in need to Count holidays for Each country for the given Month in a particular year..!! i have tried with Countifs function but its not working Thanks & Regards Kumar

I'm writing an electronic survey on excel as per my employer's request. If the respondent clicks "fail", I don't want to count any of the "pass" responses for a particular section. I'm currently counting the repsonses as so: =COUNTIF(E33:E42,"x") That section of the survey looks like this...

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

Really struggle with Excel, so this might be a quick and easy one for someone out there?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I want to conditional format a worksheet, which is to check for two criteria’s in two columns to capture...

I want to use a COUNTIF formula to count how many times cells with a range contain specific words. Each cell will contain four words but I only want to count 2 of them. For example: Cell 6B contains the term BAN10 (one of the words that I want to count), Cell E2 contains the term EB (yet...

Hi all, I thought this was potentially an easy problem to solve. I am by no means an expert in excel but i can manage the straight forward formulas. However i need someone's help in this scenario: I have a set of people whom i am monitoring. My spreadsheet needs to capture how many mistake...