=SUMIF(DateRange,"="&X2,SumRange)-SUMIF(DateRange,""&Y2,SumRange)

where X2 is a true date like 1-Mar-05 and Y2 is either 31-Mar-05 or
computed from X2 with:

=DATE(YEAR(X2),MONTH(X2)+1,0)

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