SUMIF on Date Range

[Robin]

I'm trying to sum a column if it falls between a date
range. On Sheet 1 Sum Column D, if the Date range entered
in A1 to D1 is in B. Am I on the right track??

=SUMIF(Sheet1!B:B, Between A1 and D1, Sheet1!D)

 

[JulieD]

Hi Robin

try
=SUMPRODUCT((Sheet1!B1:B100>A1)*(Sheet1!B1:B100<D1)*Sheet1!D1100)

you can't use column references in SUMPRODUCT functions so just set the
range to be big enough to cover your values
hope this helps
Cheers
JulieD

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--('sheet1'!B1:B100>A1),--('sheet1'!B1:B100<A1),'sheet1'!D1
100)

Note: SUMPRODUCT does not allow ranges like B:B