Home |
Search |
Today's Posts |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible for excel to take several cells in random order and | Excel Discussion (Misc queries) | |||
Random selection of text cells | Excel Discussion (Misc queries) | |||
(djn) Excel Not Updating Random Cells | Excel Discussion (Misc queries) | |||
Sum of random cells with positive data | Excel Discussion (Misc queries) | |||
random selection from a range of cells | Excel Worksheet Functions |