Adding multiple lines up and getting a total

[Warren griggs]

Hi,

I have a file that looks like this...

45
34
23

What I need to do is add each line up to get a total.

ie for the example above ...

45+34+23 Total = 102

I think I need to use awk for this but cannot remember how.

Any help would be great.

Thanks,
Colin.

[Geoff Wild · Accepted solution]

Try this:

awk 'BEGIN {total=0;} {total=total+$1;} END {print total,"\n";}'

Rgds...Geoff

[Patrick Wallek]

If the file just contains the single value you could do:

#!/usr/bin/sh

TOTAL=0
for i in $(cat file)
do
let TOTAL=$TOTAL+$i
done

echo "The total is $TOTAL"

[Jarle Bjorgeengen]

awk 'BEGIN {total=0} {total=total+$NF} END {print "Total is : " total} ' filename

Rgds Jarle

[Robin Wakefield]

...or...

perl -lne '{$t+=$_}END{print $t}' filename

rgds, Robin

[Jean-Louis Phelix]

Perhaps you will like this one ...

echo $(($(cat file | tr '\012' '+')0))

Regards.

[Chris Vail]

In Unix, there's always several different ways to do any one thing. You've already got some good ones, here's another:
#!/bin/ksh
for AMOUNT in `cat $FILE`
do
(( TOTAL = "$TOTAL" + "$AMOUNT" ))
done
echo $TOTAL

Chris

[John Meissner]

or yet another way....

number=$(cat file)
e=0
for i in $number
do
((e=e+$i))
done
echo $e

now if you have multiple columns in your file you can just change the value to $number to assign the field you wish to add up.

i.e.
number=$(cat file | awk '{print $2}')

and the 2nd field would be added