sumifs using dynamic criteria

[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!

 

[Billy Liddel]

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

 

[Herbert Seidenberg]

Excel 2007 Tables
With Sumifs and Structured References
http://www.mediafire.com/file/zomnd4nozic/09_21_09a.xlsx