Eventually yes, I need to add the value of each column. But first is there a
way to put a check box or button in each cell that allows the user to select
ONLY ONE of the three columns at a time. And when the selection is made I
want a specific value to be assigned to that cell (as indicated below). Then
I need to add the total 'value' for each column.

"Jacob Skaria" wrote:

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, each cell has value of 1
Column B, each cell has value of 2
Column C, each cell has value of 4

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