Multiple conditions

[Curtis]

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

 

[Bob Phillips]

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

 

[Bernard Liengme]

Please tell us more about the data

 

[Curtis]

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

 

[Ashish Mathur]

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