View Single Post
  #25   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] 1stchoicehiring@gmail.com is offline
external usenet poster
 
Posts: 1
Default How do I sum up random cells

On Friday, April 25, 2008 at 1:11:01 AM UTC-6, Josh W wrote:
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.


Hello does anyone who how to get the sum of a random cells..

example i am working on a project of comparing prices but i dont want to compare all the prices of all the products just the ones i need at that time.