Count between dates by type
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 |
Count between dates by type
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 |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com