Calculating information from auto-filtered data.

[farmertml]

Hi,

I have been having alot of trouble with a spreadsheet and have managed to overcome some huge hurdles until now, and I'm really stuck in a rut.

If you look at my spreadsheet the main focus is on the Final Results page.

I currently have the data in one sheet which I then autofilter to find out the percentage rejection :- For example select Grower (Grower9), Product (Lillies Stores), Variety (Orientlstd). This the shortens the list to about 14 items which I then work out by hand.

What I want to achieve is on the Grower Summary page, to work out the overall percentage of rejection I.E. = (Sum of data matching critera in Row F / Filtered data of Sum of Row E) * 100.

The next problem I have then is I want to be able to do it quickly / automatically based on the content (It doesn't have to autofilter on this sheet, it's just like that to make my life easier at the moment), so it will work out all of the growers / products / varities and put them onto a seperate summary page for each grower.

Please see the attached sheet!

Many thanks for any help you will be saving my life!