Parts Per Million Formula

[Guest]

I need to generate a 6 month rolling PPM formula and I have no idea where to
start. It needs to automatically select the last six months of data and
calculate it into PPM accurately. any help would be greatly appreciated.

 

[Bill Kuunders]

you'll need to send more data

or send me a copy of the file direct

 

[Guest]

The formula is generally the amount rejected/the amount shipped*1000000, with
an if then statement preceding that says IF(amount shipped=0,0. My data is
organized in columns with headers of the months april to december with the
amount shipped and rejected for each company under each month. So in total
theres nine months, but i need to build the formula to function even if more
months are added. I know its hard to explain, but im not very familiar with
this forum and i dont know how to post an attchment of the file for you to
take a look at.

 

[Bill Kuunders]

Rachel
By "direct" I meant.... send me a copy of the file to my email address.

By the way.... the end result
is it going to be an average of the ppm's per month
or is it a recalculated ppm of "the total send" divided by "the total
rejected"
for the 6 months

Bill K