General Topics
Markets
Technical Topics
Brokerage Firms
Company Specific
Community Lounge
Site Support

# Excel question

Discussion in 'Trading Software' started by CasperCRF, Oct 18, 2005.

1. ### CasperCRF

Does any one know how to do an average of more then 30 numbers in excel? The function AVERAGE(A1:A30) can only do up to 30 numbers and I want to try to do and average of around 120. Am I missing something? I don't know why I can't figure it out.

2. ### thenewguy

the AVERAGE function can do much more than 30 numbers, it looks like the problem is the range you are specifying: A1:A30. Try changing the "A30" to the last row in your A column with data in it. Alternatively, you can just put AVERAGE(A:A) and that will average all populated cells in the A column.

-The New Guy

3. ### Bob111

put mouse cursor at last number of first 30, on right lower corner. you mouse arrow will look like little cross. grab last number and hold with right click with cross on. go down to last number. all calculations will be done automatically.

did you tried

=average(A1:A120)

maybe some of the numbers in cells are strings ?

hope you can understand my english

4. ### CasperCRF

The problem is that I'm not trying to do all the numbers in a column, I'm trying to get my average win and my average loss of 120 trades. So the column has both positive and negative numbers in it. I was doing AVERAGE(number1,number2,...,...,) and so on but it will only let you do up to 30 numbers that way.

5. ### thenewguy

Ah, well that's different. In that case, I'd put "=If(A2>0,A2,"")" in B2 (or your first free cell in the 2nd row) and copy it down the whole dataset. Mark it "wins" then just average that whole column like I described above.

I'll post and example in a second....

- The New Guy

6. ### thenewguy

here you go...

7. ### thenewguy

errrr, here you go

File size:
13.5 KB
Views:
43
8. ### CasperCRF

That worked, thanks!

9. ### thenewguy

Any time!

- The New Guy

ET IS FREE FOR TRADERS BECAUSE OF THE FINANCIAL SUPPORT FROM THESE SPONSORS: