awk command: print output to specific column in new file

[Pangolin]

Hi.
I need to sum the integer values contained in column n. 1 of file VALUES.cvs and print the result into file RESULT.csv but in column n. 3.
How can I achieve that?
My knowledge of the awk command just ends here:

Code: Select all

awk '{sum += $1} END {print sum}' VALUES.csv > RESULT.csv

but it obviously prints the result in the first column of RESULT.csv
Any ideas?
Thank you.

[1000]

This is not a direct solution.
https://stackoverflow.com/a/9506868


Problems:
- I much prefer bash
- " values contained in column n. 1 "
I don't see example.
* I don't see if they are separated by a space or something else.
* If there is only one number in the first column, then where is the next number?