Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct syntax when using AND, OR
I have a list of trouble tickets with ticket#, open and close dates recorded
like this: A B C 1234 05/01/07 06/15/07 4567 04/01/07 07/15/07 4321 05/29/07 Timeframe is recorded like this: D1=06/01/07 D2=06/30/07 I am trying to write the condition below as a SUMPRODUCT. Condition: (open<D1) && ((close=) || ((closeD2) && ((close-open) 30))) Formula: =SUMPRODUCT((B1:B3<D1) AND ((C1:C3=) OR ((C1:C3D2) AND ((C1:C3-B1:B330))) What are the formula notations for AND and OR? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IRR Syntax | Excel Worksheet Functions | |||
Help with Syntax | Excel Discussion (Misc queries) | |||
SQL syntax | Excel Worksheet Functions | |||
Sumproduct syntax - more complex | Excel Discussion (Misc queries) | |||
Syntax Help | Excel Worksheet Functions |