You use an array. Check out Chip Pearson's website....
http://www.cpearson.com/excel/array.htm
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"Bryan Brassell" wrote:

Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif.