criteria multiple

Hi All, The situation that I have is the following: Sheet1: (start and end times of orders) Machine (CELL B1) OrderNumber (CELL E1) StartTime (CELL P1) EndTime (CELL Q1) Machine1 00001 Machine2 00002 Machine3 00003 Machine4 00004 Machine1 00005 Machine2 00006...

Hello I need to add a second condition in to this formula, the additional criteria is in cell G3. Where/how would I add this in? =SUMIF(INDIRECT("'"&$C$3&"'!d:d"),A:A,INDIRECT("'"&$C$3&"'!h:h"))

Dear, I have the following issue, and looking for possible assistance. The formula I currently have is broken into three pieces: It looks at cell A4 if empty, otherwise to process the second part... It looks if a separate table column E:E contents, and compare with a concatenation of active...

In the below formula I want to convert the Sum formula to not count for duplicates. I will explain this further. =SUM(($BB$7:$BV$384)*(--(A7:A384=A16)*(B7:B384=B16))) With the above formula I am summing the total dollar amounts in a range based on 2 criteria (2 other columns). I tried...

Good morning, everyone! :) I have a frequency/sum formula that looks at individuals who meet multiple criteria and then provides a unique number of those individuals. For example, 72 line items match my criteria but only 63 are unique users based off the member ID field. I am running in to a...

Ok - usually I can search these message boards or find a YouTube video, it's just not happening for me today. I am looking to count unique ID's in one column that meet criteria in three other columns. Column G = "" (blank) Column O = Completed Column L - Coaching Column F contains my ID's I...

=SUMPRODUCT((August!I:I="No notes added")*(August!J:J="John Smith")) =SUMPRODUCT((August!I:I="Notes added")*(August!J:J="John Smith")) Hello, I am trying to implement this formula into my spread sheet. I have multiple names which I need to count 1 if notes have been added or not for stats...

Hi, I am doing a price comparison and want to add a field for average price. However not all fields are populated on every row so cannot simply add up and divide by total. Therefore I am trying to do a countif to show only populated cells. I cannot use simply countif >0 as I have another cell...

Hello Everyone, I am in a bit of a pickle. Before I came here to post a thread - I did some research and could not find a solution using COUNTIFS ; the closest I have come to is using 'sumproduct' which in my excel spreadsheet for some reason it is not working. Basically what I have is an excel...

It is hard for me to describe what exactly I am looking for. Perhaps it is best that I try to illustrate it with my example. A1: Date A2: 10/1/2014 A3: 10/2/2014 A4: 10/9/2014 A5: 10/10/2014 B1: SKU B2: T001 B3: T002 B4: T001 B5: T002 C1: PRICE C2: 12 C3: 5 C4: 13 C5: 6 Suppose, A8 is my...

Hi there, I need to find names from one column based on a criteria on another column. I would normally do this using INDEX/MATCH function. However, the challenge I have is that I need to list in order (doesn't have to be alphabetic) all the names that match the criteria. I have shared below a...