View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jag Jag is offline
external usenet poster
 
Posts: 16
Default 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.