Need help ASAP,pivot table or best option for data summary

[JENESIS9777]

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a spreadsheet containing loads of data which I add to daily. I need to summarize the data in a few ways, and keep running totals. I need to be able to count how many items were entered by day, week, month and year overall, and how many items per day, week, month and overall that met certain criteria that were new (H) and active (J). for example:<o></o>
My sheet contains the following columns of information: (the data is placed in rows, the headers are the columns listed below.)<o></o>
<o></o>
Columns:<o></o>
B: DATE REVIEWED<o></o>
H: NEW ITEM OR COPY<o></o>
J: ACTIVE OR EXPIRED<o></o>
K: TYPE OF DOCUMENT<o></o>
<o></o>
It would be great to have a summary sheet that shows the quick totals for all the data entered. <o></o>
<o></o>
Summary needs (would be great to see in bar graph form as well) <o></o>
Example<o></o>
<o></o>
April 1st 2010:<o></o>
100 items reviewed, <o></o>
10 were new and active, <o></o>
total reviewed for month of April 900, <o></o>
total new and active for April 50.<o></o>
Etc.<o></o>
<o> </o>
I need to see a quick summary per date, per month and overall of reviewed and how many were new and active. I currently am using a count if formula if H and J = New and active, but it calculates for overall total only, I don't know how to break it down to monthly or daily.<o></o>
<o></o>
THANK YOU SO MUCH!<o></o>
<o></o>
<o></o>
Need help on this asap <o></o>

 

[JENESIS9777]

I forgot to mention that I will eventually need to summarize how many of each document type as well.

 

[jamieleeuk]

Hi Jenesis,

I think a snippet from your worksheet is needed so we can understand better what it is you want your results to be.

 

[lenze]

From your description, I think a Pivot Table and Pivot Chart would work for you!! Have you tried it?

lenze