Date Function

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hello,

Is there a formula that can do this- In column F for
example I have a list by DATE of homes that were sold from
the past few years and on another worksheet I want a
formula that will tell me the sales by month and year Like-
1/04- 5
2/04- 6

I'm doing it manually now and I would love to make it
automatic.

Thanks
Brian
 
Hi
one way:
=SUMPRODUCT((F1:F100>=DATE(2004,4,1))*(F1:F100<DATE(2004,6,1))
to count all sales between 04/01/2004 and 06/01/2004

if column G stores a sales amount you could use
=SUMPRODUCT((F1:F100>=DATE(2004,4,1))*(F1:F100<DATE(2004,6,1),G1:G100)
to sum the sales amount for a specific period

You may also have a look at pivot tables for analyzing your data. Some
starting points:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
 
Back
Top