"Ed" wrote in message
...
(1) I simplified things for the question, but I may have been too simple
with regards to the date. Rarely will it be that clean - it will be more
like =2003104 AND <=20040323. I can't how to fit "between this date and
that date" into the formula you provided.

See my previous response on how to do that.


(2) If I read you right, I can't just select an entire column and name
it;
I have to just select the used range and name that only?


You are right, SUMPRODUCT, unlike SUMIF, doesn't take whole columns.