Autopopulate and sum data based on criteria into another worksheet.

[LWithers]

Ok, so I have two charts here that track TAGS that we write for our presses. I would like a formula or code to be able to pull data from the first chart to populate the second chart in another worksheet. I want the formula/code to have an "if" statement to determine whether the "Pillar" is AM, PM, or Safety, and then have an "if" statement determining what week the "Date Issued" falls into. Then, with another "if" statement, I need it to determine whether the "Status" is "Open" or "Closed" and have it populate the data into the corresponding cell on the other chart.
Since there is only one cell corresponding to each week, I would then need the formula/code to sum the total number of tags in each week with the same criteria (PM open for example).

Pillar	Date Issued	Status
AM	16-Jan-13	Closed
AM	26-Jan-13	Open
Safety	4-Feb-13	Closed
PM	11-Feb-13	Closed
AM	20-Feb-13	Closed
PM	3-Mar-13	Open

<TBODY>
</TBODY>

	Week 1	2	3	4	5	6	7	8	9
PM Tags Issued
PM Tags Closed
AM Tags Issued
AM Tags Closed
Safety Tags Issued
Safety Tags Closed

<TBODY>
</TBODY>

 

[Stan_C]

Edited formula above^^^^

Ok, no problem. I really appreciate the help too, btw.

Anytime!!

I misread your first post by thinking that you wanted all tags issued static, not to change with closed.