Average statement problem

[rvd48]

hi, i have an average statement which calculates the average prices =AVERAGE(IF(AG7:AG16<>0, AG7:AG16,"")) from a list of figures, this list of figures looks at table and selects the prices using an IF statement which looks at a drop down list and selects the corresponding value from cell 'J7' if the statement is true =IF(C7="infoprint 4100", J7, 0).

if the cell J7 has the price in it but also some writing it skews my AVERAGE figure in the average calculation cell, can any1 provide assistance on how i can modify my average formula so it wont skew if i have writing as well as the standard price in it?

cheers rvd.

 

[rvd48]

i.e. if i do the average of a list of figures, and if 1 of these figures has a few words in it, it changes the average calculation value. it seems to ignore the cell with a figure and writing in it, what can i change in my average statement that makes it ignore the few words that it may see in the list of figures and just purely see a list of figures?

 

[unmarkedhelicopter]

Post a sample and show what you think the result should be vs what is calculated.