See the answer to your first post.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JerryS" wrote in message
...
Columns are as follows:

Date Color Quantity
01/01/06 Red 100
01/10/06 Blue 100
01/15/06 Red 100
01/25/06 Blue 100
01/30/06 Red 100

I need help costructing a SUMPRODUCT or SUMIF formula (or other) that
gives
me the total by color between 01/01/06 and 01/30/06. Help is appreciated.
Thanks
--
JerryS