OK, so, let's say you have your year/month in column P and your issue type in
column B...

Then, in your Summary, say your input cell for month/date is B2 and Your
entry for issue type is C2.

Then:

=sumproduct(--('Data'!P2:P10000=B2),--('Data'!B:B10000=C2))

Gives count of the type you entered during the month entered.

Let's say the costs are in coolumn C, then:

=sumproduct(--('Data'!P2:P10000=B2),--('Data'!B2:B10000=C2),--('Data'!C2:C10000)

Hope that makes sense!!

Will provide that value.

"Jeremy" wrote:

I am attempting to create a summary sheet for a rather large tracking
worksheet. It track individual complaints and their cost to the company.
There are two sheets that I am using Data (where information is entered) and
Monthly Summary (speaks for itself)

The date of the complaints is logged in the Data sheet. A formula
=IF(MONTH(N7)<10,YEAR(N7)&" "&MONTH(N7),YEAR(N7)&" "&MONTH(N7)) breaks down
the month and year for the complaint.

On the summary tab I have a cell that requires the input of that month and
date combiniation. All of the data that I want counted or added up needs to
be based on the data relevant to the month.

**This means that when I type in the date and month in the summary tab, all
of the subsequent data will change.

I am looking to count certain occurances (# of complaints in 2008 1 with the
reason category Non Sales Admin Pricing)

And

I am looking to add the dollar value of certain occurances ($ value of all
occurances in 2008 1 with the reason category Non Sales Admin Pricing)

What I would really like is instead of using the ="Non Sales Admin Pricing"
is reference it to a cell so I can autofill certain other cells with the same
needs.

I have tried to communicate this as well as I can. If you would like to see
a copy of the sheet I am more than willing to emaiol it to you.

Thanks
Jeremy