Total entries per month formula

Hello,

I'm not sure whats the best way to explain my problem but here it goes:

I have a spread sheet which is updated at least weekly.

It has different part number with priority statuses which include P1, P2 and P3.

All i want is a formula to calculate how many of each priority statuses there are for each month

However, some parts may be taken off the sheet within the month, which i still want to include into the total as it was still included in 'August' (This is my issue)

The part will be transferred to a different page on the document as it was 'un-sourced' and is now 'sourced'.

Also, if a part is added in August, but is still showing in September, then i want it to appear on both until it dissappears.




sooo, if it is taken off 1st septmber, i still want it to be shown in September totoal as it was still appearing in this month, and then in onctober it will not show.

I want this in a fomula as i then have to create a macro to create a graph

The spread sheet is attached and the priority status is shown in column F on the un-sourced pageunsource 2.xls

That does not work on ym spread sheet.

I need the total amount of P1, P2, P3 for each month.

The parts will change weekly so i need a formula which will not change when parts are taken off, however, i do need it to add on parts if they are added in the month stated

Even though the month added says august, if it is still showing in september, i want it to be included in both as it is not yet completed

Please Help!