TK, without more data there isn't to much to go off of here, but I
would take a look at SUMPRODUCT. You should find some helpful examples
here, or tweak the search to get something more like what you need.

Follow the Link Below:
http://groups.google.com/group/micro...mproduct+dates

Hope that gets you started—Lonnie M.