View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default select a column, then add rows of each column

Do you mean formula to sum an entire column

=SUM(A:A)

If this post helps click Yes
---------------
Jacob Skaria


"darcy" wrote:

First - Worksheet recipients will need to select only 1 of the following
columns:
Column A, has value of 1
Column B, has value of 2
Column C, has value of 4

Then - Need to have formula to add total value of each column