Multiple conditions
 

I need a formula that will count the number of instances identified in column
M by month (column K). Note column K will have varing days of the month,
month of the year.

I need this summarized in a summary sheet

ex:

Jan Feb Mar Etc..
car 1
boat 4
ship 5
bike
etc€¦

Thanks

Multiple conditions
 

=SUMPRODUCT(--(Sheet1!$K$2:$K$200=B$1),--(Sheet1!$M$2:$M$200=$A2))

--
__________________________________
HTH

Bob

"Curtis" wrote in message
...
I need a formula that will count the number of instances identified in
column
M by month (column K). Note column K will have varing days of the month,
month of the year.

I need this summarized in a summary sheet

ex:

Jan Feb Mar Etc..
car 1
boat 4
ship 5
bike
etc.

Thanks

Multiple conditions
 

Please tell us more about the data
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Curtis" wrote in message
...
I need a formula that will count the number of instances identified in
column
M by month (column K). Note column K will have varing days of the month,
month of the year.

I need this summarized in a summary sheet

ex:

Jan Feb Mar Etc..
car 1
boat 4
ship 5
bike
etc.

Thanks

Multiple conditions
 

Sheet 2 contains raw data that lists various data by date purchased and asset
purchased. The assest could be anything in column M and the date could be any
day in any month in any year.

In my summary page, Sheet 1, I will list all the assest in the portfolio
vertically say in cloumn A rows 3 through 15. I will also list the month
horizontially in row 1 column B through M.

I need a formula that will look at sheet two and look at the both the assest
and date purchased and associate it to the month and assest in sheet 1.

Date in sheet 2 is formated as 1/26/2009.
Date in sheet one is formated as Jan 09


Thanks

"Bernard Liengme" wrote:

Please tell us more about the data
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Curtis" wrote in message
...
I need a formula that will count the number of instances identified in
column
M by month (column K). Note column K will have varing days of the month,
month of the year.

I need this summarized in a summary sheet

ex:

Jan Feb Mar Etc..
car 1
boat 4
ship 5
bike
etc.

Thanks

Multiple conditions
 

Hi,

This question is a perfect candidate for a pivot table. Create a simple
pivot table (Data Pivot Table and pivot chart report). Now drag the date
to the column area and asset to the row area. Drag asset to the data area
as well. Now while inside the pivot table, click on "Group and Show detail"
in the pivot table toolbar and select months. Now you will see months
instead of dates in the column area.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Curtis" wrote in message
...
Sheet 2 contains raw data that lists various data by date purchased and
asset
purchased. The assest could be anything in column M and the date could be
any
day in any month in any year.

In my summary page, Sheet 1, I will list all the assest in the portfolio
vertically say in cloumn A rows 3 through 15. I will also list the month
horizontially in row 1 column B through M.

I need a formula that will look at sheet two and look at the both the
assest
and date purchased and associate it to the month and assest in sheet 1.

Date in sheet 2 is formated as 1/26/2009.
Date in sheet one is formated as Jan 09


Thanks

"Bernard Liengme" wrote:

Please tell us more about the data
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Curtis" wrote in message
...
I need a formula that will count the number of instances identified in
column
M by month (column K). Note column K will have varing days of the
month,
month of the year.

I need this summarized in a summary sheet

ex:

Jan Feb Mar Etc..
car 1
boat 4
ship 5
bike
etc.

Thanks