J
Jeremy
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
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