Criteria in sumif function

  • Thread starter Thread starter john
  • Start date Start date
J

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.
 
then it might be better to use where rngA contains the >= and < and rngB is
to be summed.

=sumproduct((rngA>=a1)*(rngA<a2)*rngB)
 
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
 
Back
Top