Two criteria to calculate

Ks1102

Well-known Member
Joined
Jan 8, 2008
Messages
672
Hi, experts

I wants have a formulas to found two criteria as column C = criteria and column D = time, example, found criteria “014”-“013” time.
The result on at cells A1,

Thanks
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

pagrender

Well-known Member
Joined
Sep 3, 2008
Messages
652
I'm not exactly sure what you are asking.

Are you asking if:
C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:
=IF(AND(C1="enter your criteria here",D1="enter your time here"),A1,0)
 

Ks1102

Well-known Member
Joined
Jan 8, 2008
Messages
672
I'm not exactly sure what you are asking.

Are you asking if:
C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:
=IF(AND(C1="enter your criteria here",D1="enter your time here"),A1,0)
pagrender

Thanks your reply and sorry the unclear asking, example here's

Cells A1 = 2:00

COL C COL D
011 10:00
012 10:30
013 13:15
017 16:00
014 15:15
068 17:21
else ....
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,819
Messages
5,513,584
Members
408,960
Latest member
dichthuatco

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top