SUMIF on Date Range

  • Thread starter Thread starter Robin
  • Start date Start date
R

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:D)
 
Hi Robin

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

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
 
Hi
try
=SUMPRODUCT(--('sheet1'!B1:B100>A1),--('sheet1'!B1:B100<A1),'sheet1'!D1
:D100)

Note: SUMPRODUCT does not allow ranges like B:B
 
Back
Top