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
Bookmarks