I have 2 columns with "1's" used to indicate a checkmark in that column. I
want to move the data from one column (eg column A) to another column (eg
column b) to consolidate the data into the one column (column b). This looks
like this:

A B into B
1 1
1 1
1 1
1 1
1 1

I would then be able to sum the numbers in column B to get a new total that
is the total of the old A and B. Thanks for your help.

As-is, if you just want the sum,
you could simply use in say C1: =SUM(A:B)

But if you want to merge cols A & B in col C:
a. If data in cols A & B contain only numbers
In C1: =IF(COUNT(A1:B1)=2,"",SUM(A1:B1))
Copy down to merge it in col C

b. If data in cols A & B contain text or mixed text/numbers
In C1: =IF(COUNTA(A1:B1)=2,"",IF(A1="",B1,A1))
Copy down to merge it in col C
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"newbie" wrote:
I have 2 columns with "1's" used to indicate a checkmark in that column. I
want to move the data from one column (eg column A) to another column (eg
column b) to consolidate the data into the one column (column b). This looks
like this:

A B into B
1 1
1 1
1 1
1 1
1 1

I would then be able to sum the numbers in column B to get a new total that
is the total of the old A and B. Thanks for your help.