ExcelBanter - Sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumproduct (https://www.excelbanter.com/excel-discussion-misc-queries/199128-sumproduct.html)

osaka78

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

Mike H

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

All times are GMT +1. The time now is 08:00 PM.