View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Sum many unconnected cells

Is there any indications in adjacent cells that these are sales tax or are
they located in a certain pattern like every 5th cell or so? If not then
there is no other way than to type

=SUM(

then select the cells manually by holding down the ctrl key and select each
cell one by one



--
Regards,

Peo Sjoblom

"Pam M" wrote in message
...
Would anyone know of an easy way to sum a large quantity of unconnected
cells
within a worksheet? The worksheet is on one sheet. We have it broken
down
into many sections within the spreadsheet and each section has a cell that
calculates salestax. I want to sum all of the cells that have salestax
into
one cell on another worksheet. Thanks!