combining if functions and data validation to do calculations

in the attached spreadsheet (tab QUOTE), there is data validation in the green cells (just the description column). when info is put in here i want tab ANALYSIS (yellow highlight) to autopopulate the task and the No. column. i can do this but get problems, ie if there is no data in the QUOTE tab it returns a #N/A error

in the ANALYSIS tab, i have a formula in f26:f31 which looks at a value in the pricing tab multiplied by the No column and then it adds it up in h32.

so what i am after is in ANALYSIS tab, i want the yellow to autiopopulate the figures based on the QUOTE tab green figures, but ignoring blank cells

hope ive explained this well enough!

thanks

works a treat, thanks!

just going back to this query. ive attached the spreadsheet to help my explanation

in the analysis tab, i want to add more rows where there are only 4 for the "sales orders" when i insert rows and input info into the "quote" tab in rows 21-28 it doesnt all show up in the "analysis" tab

hope you can help

when i insert cells in (SEE ATTACHED) it doesnt work!! cannot drag the formula down

great thanks very much!