Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

arjen92

macrumors 65816
Original poster
Sep 9, 2008
1,066
0
Below sea level
He,

I've filled a lot of value's into numbers, and with "function" I made numbers calculate the average of all the values. I made several different .numbers files and I want to put all the "average" values together (in each .numbers files are 38 average value's, I've got 10 .numbers files).

When I select al the average value's (made by the function average) copy them and place them in a new file their appear red triangles, instead of the values. I think this is because it copy's the function (take the average of all above values). But I don't want the function, I want the value's, to continue calculating with them.

(The values are answers from tests, I want to know what people average answered, I had different classes of people, so I have a file with what males think, and a file what females think etc).
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.