I like it Spiky, I don't know why I never thought of that before. Derhh!!

Regards
Martin


"Spiky" wrote in message
...
On Apr 25, 4:43 am, "MartinW" wrote:
Hi Josh,

Another way, type =SUM( in the cell where you want the total,
Then click on your first cell and tap comma
click on the second cell and tap comma etc. etc.

You are limited to 30 numbers but any contiguous range in the
selection will only count as 1 number. i.e =SUM(A4,C7,D7:D13,F15)
would only count as 4 numbers.

Obviously it is still a bit awkward, but it is better than typing
out the formula.



Select the random cells using CTrl-Click, then look in the bottom
right
of
the statusbar, you will see a sum. If it is count, right-click and
select
SUM.

--
HTH

Bob



You can combine these 2 suggestions I quoted for a bit faster usage.
Type =SUM( or just hit Autosum button, then CTRL-Click all the random
cells that you want.