Jenny

One way:

=AVERAGE(A1:A20+B1:B20)

This is an array formula and it must be entered with
<Shift<Ctrl<Enter, also if edited later.

Similar for STDEV.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Jenny" skrev i en meddelelse
om...
Say I have two columns (A and B) going from rows 1 to 20. Is there
some elegant way to add the numbers across each row, THEN take the
average and stdev of the column(besides making a new column with the
sum across the row)? I've done it (inelegantly) by doing:
=AVERAGE(A1+B1, A2+B2, A3+B3, .... , A19+B19, A20+B20)
and
=STDEV(A1+B1, A2+B2, A3+B3, .... , A19+B19, A20+B20)

it works, but it looks bad... just wondering if there was a better
way...

Thanks!