i need your on this

I have one coloum fill of sales dates figures from year 1999 till 2007

I need formula to give sales figures form month August 2004 or April 2002

date formated 8/19/1999

Regards

Tell us your layout and give examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
message ...
i need your on this

I have one coloum fill of sales dates figures from year 1999 till 2007

I need formula to give sales figures form month August 2004 or April 2002

date formated 8/19/1999

Regards

Hi,

Delivered date Year
30-Dec-01 2001
30-Nov-00 2000
22-Nov-02 2002
22-Aug-02 2002
30-Jul-00 2000
30-Nov-00 2000
21-Aug-02 2002
11-Jan-08 2008
21-Oct-07 2007

I need formaula to give all sales figures month august in year 2002


"Don Guillett" wrote:

Tell us your layout and give examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
message ...
i need your on this

I have one coloum fill of sales dates figures from year 1999 till 2007

I need formula to give sales figures form month August 2004 or April 2002

date formated 8/19/1999

Regards

Which column is your sales figures in? These are just dates.

Pete

On Jan 20, 8:45*am, George A. Jululian
wrote:
Hi,

Delivered date *Year
30-Dec-01 * * * * * * * 2001
30-Nov-00 * * * * * * * 2000
22-Nov-02 * * * * * * * 2002
22-Aug-02 * * * * * * * 2002
30-Jul-00 * * * * * * * 2000
30-Nov-00 * * * * * * * 2000
21-Aug-02 * * * * * * * 2002
11-Jan-08 * * * * * * * 2008
21-Oct-07 * * * * * * * 2007

I need formaula to give all sales figures month august in year 2002 * * * * * *



"Don Guillett" wrote:
Tell us your layout and give examples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
...
i need your on this

I have one coloum fill of sales dates *figures from year 1999 till 2007

I need formula to give sales figures *form month August 2004 or April 2002

date formated 8/19/1999

Regards- Hide quoted text -

- Show quoted text -

Hi

column delivery date is sales of the month

i want to find out how sales been made on august 2001 or sales been made on
september 2005

regards

"Pete_UK" wrote:

Which column is your sales figures in? These are just dates.

Pete

On Jan 20, 8:45 am, George A. Jululian
wrote:
Hi,

Delivered date Year
30-Dec-01 2001
30-Nov-00 2000
22-Nov-02 2002
22-Aug-02 2002
30-Jul-00 2000
30-Nov-00 2000
21-Aug-02 2002
11-Jan-08 2008
21-Oct-07 2007

I need formaula to give all sales figures month august in year 2002



"Don Guillett" wrote:
Tell us your layout and give examples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
...
i need your on this

I have one coloum fill of sales dates figures from year 1999 till 2007

I need formula to give sales figures form month August 2004 or April 2002

date formated 8/19/1999

Regards- Hide quoted text -

- Show quoted text -

Are you looking for this kind of solution? Assume Column A has your dates as
real date values and not as text values. In B1 put the **number** for the
month you want to search for and in B2 put the year number. This formula
will give you a **count** of how many dates in Column A meet your month/year
requirement...

=SUMPRODUCT((MONTH(A1:A1000)=B1)*(YEAR(A1:A1000)=B 2))

Rick



"George A. Jululian" wrote in
message ...
Hi

column delivery date is sales of the month

i want to find out how sales been made on august 2001 or sales been made
on
september 2005

regards

"Pete_UK" wrote:

Which column is your sales figures in? These are just dates.

Pete

On Jan 20, 8:45 am, George A. Jululian
wrote:
Hi,

Delivered date Year
30-Dec-01 2001
30-Nov-00 2000
22-Nov-02 2002
22-Aug-02 2002
30-Jul-00 2000
30-Nov-00 2000
21-Aug-02 2002
11-Jan-08 2008
21-Oct-07 2007

I need formaula to give all sales figures month august in year 2002



"Don Guillett" wrote:
Tell us your layout and give examples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian"
wrote in
...
i need your on this

I have one coloum fill of sales dates figures from year 1999 till
2007

I need formula to give sales figures form month August 2004 or
April 2002

date formated 8/19/1999

Regards- Hide quoted text -

- Show quoted text -

Many thanks for your help and support

regards

"Rick Rothstein (MVP - VB)" wrote:

Are you looking for this kind of solution? Assume Column A has your dates as
real date values and not as text values. In B1 put the **number** for the
month you want to search for and in B2 put the year number. This formula
will give you a **count** of how many dates in Column A meet your month/year
requirement...

=SUMPRODUCT((MONTH(A1:A1000)=B1)*(YEAR(A1:A1000)=B 2))

Rick



"George A. Jululian" wrote in
message ...
Hi

column delivery date is sales of the month

i want to find out how sales been made on august 2001 or sales been made
on
september 2005

regards

"Pete_UK" wrote:

Which column is your sales figures in? These are just dates.

Pete

On Jan 20, 8:45 am, George A. Jululian
wrote:
Hi,

Delivered date Year
30-Dec-01 2001
30-Nov-00 2000
22-Nov-02 2002
22-Aug-02 2002
30-Jul-00 2000
30-Nov-00 2000
21-Aug-02 2002
11-Jan-08 2008
21-Oct-07 2007

I need formaula to give all sales figures month august in year 2002



"Don Guillett" wrote:
Tell us your layout and give examples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian"
wrote in
...
i need your on this

I have one coloum fill of sales dates figures from year 1999 till
2007

I need formula to give sales figures form month August 2004 or
April 2002

date formated 8/19/1999

Regards- Hide quoted text -

- Show quoted text -