A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I sum up random cells

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old February 26th 10, 01:47 PM posted to microsoft.public.excel.worksheet.functions
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?

"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,D713,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.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
is it possible for excel to take several cells in random order and confused in Iowa Excel Discussion (Misc queries) 1 January 7th 08 03:17 AM
Random selection of text cells CJ Excel Discussion (Misc queries) 3 September 10th 06 07:05 AM
(djn) Excel Not Updating Random Cells djn Excel Discussion (Misc queries) 1 May 18th 06 08:15 PM
Sum of random cells with positive data Susannah Excel Discussion (Misc queries) 2 February 18th 05 10:28 AM
random selection from a range of cells tjb Excel Worksheet Functions 1 February 15th 05 06:34 PM

All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.