On Tue, 8 Mar 2005 21:39:04 -0800, "the_kane"
wrote:

in column A is list of dates populated each day of the year from jan 1st to
dec 31st. And In column b i have the sales $ for that day. there is more than
1 sales entry for each day, hence multiple entries using the same date.

How do i have a summary table that shows only total sales between certain
time periods. eg march, or may

Eg, only sales from Column B, matching the date in colum A between 1-mar-05
and 31-mar05.

I was thinking: TO SUM SALES VALUES FROM COLUMN H1:H365 ONLY IF(A1:A365,
= 1 MAR 05 AND <=31 MAR 05

In addition to the posted solutions, you could also investigate the use of a
Pivot Table. You would be able to group the sales by months.


--ron