| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write an Or statement inside Sumproduct?
Using xl-2007
I reallize that the OR statement cannot be used as an array in a Sumproduct. In this case how can I sum the values in column D or count the rows where columns A & B = t and column C = x Or y? A B C D 1 t t x 10 2 t f x 5 3 t t y 10 Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect(NamedRange) inside Sumproduct | Excel Worksheet Functions | |||
| how can i write complex numbers inside excel cels? | Excel Discussion (Misc queries) | |||
| vlookup inside an if statement? | Excel Discussion (Misc queries) | |||
| vlookup inside an if statement? | Excel Worksheet Functions | |||
| Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
Threaded Mode
