View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_355_] Rick Rothstein \(MVP - VB\)[_355_] is offline
external usenet poster
 
Posts: 1
Default How do I sum up random cells

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.