How can i do a formula that will calculate the average of a few cells as long
as the cell is over a certain amount... ??

Eg, i have

40
42
45
30

I would like the average of all of them expect any that are lower than 35

e.g if(a1:a4<35,takeaverage,ifnotexcludeanythinglower)

^^ i know that will not work but i am sure someone will know how to make it
work..



Can you help ?



Also i would also like to may a graph with the above information selecting
all the 4 cells, but would not like anything other than 3.30 on the graph...
Is this possible?