View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh W Josh W is offline
external usenet poster
 
Posts: 55
Default How do I sum up random cells

Rick, let me try to explain better. Say I want to add up the values of 40
different cells which are located all over the page (not in order neither
vertically nor horizontally). How do I do that? If I were to follow your
advice and type in the + sign and the cells it would take me for
ages...Thanks.

"Rick Rothstein (MVP - VB)" wrote:

If your question is as simple as it sounds, then just put an equal sign in
front of what you posted and place that in a cell...

=A2+A7+C4+D7+G3

However, you use of the word "random" in the subject line seems to indicate
you might have a more complex question... do you?

Rick


"Josh W" wrote in message
...
I want to add up the values of various discontiguous cells in a worksheet
e.g. A2+A7+C4+D7+G3. What is the quickest way to do this? The autosum
function doesn't seem to work for this. Excel 2003. Thanks.