I'm confused. If you only have products in ro2 2-32, how do average the
last 1000?

--

HTH

RP

"americanenergy"
<americanenergy.21sicz_1137519907.4604@excelforu m-nospam.com wrote in
message news:americanenergy.21sicz_1137519907.4604@excelfo rum-nospam.com...

Hi. I have a need for a formula that has me stumped. The first Colum is
user entry of products used per day with a entry total in row 33 from
the sum of 2 to 32 in column a. The second column is user entry for
broken (unusable product) for that day with a total in row 33 from the
sum of 2 to 32 in column b. The third column is the percentage of
unusable product verses total product per user entry (Example B2/A2)
with a total average percentage of broken product to usable product in
row 33 from the average of column c rows 2 thru 32. This was very
simple but now I need a cell to provide me with the percentage of broke
products for the last 1000 entries, not using any of the entered
information above 1000 products used.Any help would be much
appreciated. I hope you understand my gibberish.So what I am looking
for is no mater the QTY user entered I will get the % of broken product
for only the last 1000 products entered or up to the first 1000 products
entered in column A..Respectfully Tom


--
americanenergy
------------------------------------------------------------------------
americanenergy's Profile:
http://www.excelforum.com/member.php...o&userid=30564
View this thread: http://www.excelforum.com/showthread...hreadid=502130