| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
