For summing...

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

jbsand1001 wrote:
I am looking for a formula that will look at cell B1 with a specific date
and only will count/add data from a column based on the date ranges provided
August 04-August 05. For example

I only want to count data between august 04 to august 05


Column A Column B Column C Column D
jan-04 August 1 2004 1 Total
Between August 04 and August 05=

February-04 2
8
Mar-04 5
Aprl-04... 1
Aug-04 3
Sept-04 1
Oct-04 1
Nov-04... 1
Aug-05 2