sumifs using dynamic criteria

  • Thread starter Thread starter Tenacious D
  • Start date Start date
T

Tenacious D

any way to use dynamic data in the sumifs function? For example, the sumifs
function I am using is below:

=SUMIFS(Table5[Quantity Open],Table5[Item Number],A360,Table5[Release
Date],"<09/28/09")

I would rather not hard code the date criteria, but point to a cell
containing the date. However, once I start adding greater than/less than to
the equation, I can't make it work.

Any ideas??? Thanks!
 
First time I've tried this, but with the data in the same sheet and the
references in D1 and D2:

=SUMIFS(Qty,Dates,"<"&D2,Item,"="&D1)

HTH
Peter
 
Back
Top