Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Logic tests in an IF Statement
I am trying to do a formula with 2 logic rules before the true false parts. *IF* finish time(Column H) is < 8:00 and customer = BtsD (Column F) *THEN* Sum Volume(Column G) that matches two tests above. Any ideas, very urgent! -- timmadge ------------------------------------------------------------------------ timmadge's Profile: http://www.excelforum.com/member.php...o&userid=31266 View this thread: http://www.excelforum.com/showthread...hreadid=509351 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Logic tests in an IF Statement
If you are trying to sum only the values that have corresponding columns that meet this criteria then you need to use SUMIF or SUMPRODUCT. There are probably better ways but here is one way to do it: Create a new column, say column J and put =IF(AND(H1<TIME(8,0,0),F1="BtsD"),"TRUE","FALSE") To Sum the values in G put =SUMIF(J1:Jn,"TRUE",G1:Gn) where n is the bottom-most active row that you will need to sum and 1 is your actual starting row. -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=509351 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Logic tests in an IF Statement
=SUMPRODUCT((F1:F122="BTsD")*(H1:H122<TIME(8,0,0)) ,J1:J122) Where your range of data is in rows 1 to 122, adjust accordingly Regards Dav PS Remember you are excluding 8:00, if you wish to have it included select <= instead of < -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=509351 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average of logic cells | Excel Discussion (Misc queries) | |||
If statement - 2 tests | Excel Worksheet Functions | |||
Logic question | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions |