Sumif between two date ranges

[David Schulman]

I have a spreadsheet where I am trying to sum a colum of
commissions if the date in the date column falls between a
range of dates. I have the formula:
=SUMIF(E2:E26,"AND(>=$J$29,<=$K$29)",G2:G26)
Where E2:E26 is the field containing the date of the sale;
J29 and K29 are cells containing the start date and end
dates of the valid date range; and G2:G26 are the numbers
I want totaled if the date in column E falls within the
valid date range. All I get is a 0. Help.

 

[Ron Rosenfeld]

I have a spreadsheet where I am trying to sum a colum of
commissions if the date in the date column falls between a
range of dates. I have the formula:
=SUMIF(E2:E26,"AND(>=$J$29,<=$K$29)",G2:G26)
Where E2:E26 is the field containing the date of the sale;
J29 and K29 are cells containing the start date and end
dates of the valid date range; and G2:G26 are the numbers
I want totaled if the date in column E falls within the
valid date range. All I get is a 0. Help.

In general, to use SUMIF for between two dates, use this construct:

=SUMIF(E2:E26,">="&J29,G2:G26) - SUMJIF(E2:E26,">"&K29,G2:G26)


--ron