| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct
a b c d
1 10/2/08 11/2/08 12/2/08 2 xy 5 10 15 3ss 9 12 16 I want to get total if from 11/2/08 to 12/2/08 and ss = 28 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumproduct
try,
=SUMPRODUCT((B1:D1=DATE(2008,2,11))*(B1:D1<=DATE( 2008,2,12))*(A2:A3="ss")*(B2:D3)) Mind the line-wrap, it's all one line. Mike "osaka78" wrote: a b c d 1 10/2/08 11/2/08 12/2/08 2 xy 5 10 15 3ss 9 12 16 I want to get total if from 11/2/08 to 12/2/08 and ss = 28 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Sumproduct again? | Excel Worksheet Functions | |||
| SUMPRODUCT except for | New Users to Excel | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
Linear Mode
