Complicated Table Functions

J

Jeremy

I am creating a summary sheet for a complaint log. I would like the summary
data to change based on the month and year that is typed in the cell on the
summary tab.

Below is the summary page data. I need help creating the formulas for
everything below the dashed line.

I can easily and quickly provide any additional data that might be helpful.
See below for locations of the data on the Data sheet:

Dollars Associated- Q7:Q9999
Reason Category- K7:K9999
Responsible Party- L7:L9999




Summary For Month 2008 1
Total Sales Dollars $-
Total Credit Dollars $14,099.53
Credits as % of Sales #DIV/0!

------------------------------------------------------------
Total Instances 0


Reason Category Simple Count Dollars Associated
Non Sales Admin Pricing
Non Sales Admin Freight
Non Sales Admin Other
Sales Admin Pricing
Sales Admin Freight
Sales Admin Other

Count By Coordinator (If Responsible) Simple Count Dollars Associated
Allie
Alma
Anne
Billie
Georgeann
Jennifer
Joan
Karen
Lorena
Tom
Other (Non Coord)


Reason by Rep

Pricing Freight Other
Allie
Alma
Anne
Billie
Georgeann
Jennifer
Joan
Karen
Lorena
Tom
 
J

Jeremy

I forgot to add that I need (would like) the table to change when the month
and date entry is changed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top