How do I sum up random cells
Hello Spiky,
What if there are #N/A values in your cell range? Any way to prevent the
SUM() function from skipping those?
Thanks,
Joe
"Spiky" wrote:
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.
|