Criteria in sumif function

[john]

I am having problems setting the criteria in a sumif
function to >a referenced cell (i.e. >B2). I would like
the criteria to be Greater than one referenced cell and
less than another referenced cell where these cells
contain dates and the range also contains dates. The
values to sum are integers.

 

[Don Guillett]

then it might be better to use where rngA contains the >= and < and rngB is
to be summed.

=sumproduct((rngA>=a1)*(rngA<a2)*rngB)

 

[Ken Wright]

Another way is to use something like:-

=SUMIF(A1:A100,">=C1",C1:C100)-SUMIF(A1:A100,">=D1",C1:C100)

where C1 is the earliest date and D1 is the later date