I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would
like to do is to combine Col A & C and sum B & D. The issue is that Col A & C
do not contain the same doctors. If Col A & C were the same then it would be
sum b & D.

Thanks

Brad

Not sure how your speadsheet is laid out. Each doctor should have his own row

Not
A B C D
Dr. A Dr. A
Dr. B Dr. C
Dr. D Dr. D


Should Be
A B C D
Dr. A Dr. A
Dr. B
Dr. C
Dr. D Dr. D

Leave Blanks if Dr. didn't give referels for certain years. Then the sum
would work properly.

"alyzar" wrote:

I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would
like to do is to combine Col A & C and sum B & D. The issue is that Col A & C
do not contain the same doctors. If Col A & C were the same then it would be
sum b & D.

Thanks

Brad

Joel,

The problem is that "col a" and "col c" dont match up. There are more ref
md's in 2006 then 2005. Is there an easier way of combining "a &c" other
than inserting rows to make the name macth up? Hope this is clear for you
Thanks
Brad



"Joel" wrote:

Not sure how your speadsheet is laid out. Each doctor should have his own row

Not
A B C D
Dr. A Dr. A
Dr. B Dr. C
Dr. D Dr. D


Should Be
A B C D
Dr. A Dr. A
Dr. B
Dr. C
Dr. D Dr. D

Leave Blanks if Dr. didn't give referels for certain years. Then the sum
would work properly.

"alyzar" wrote:

I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would
like to do is to combine Col A & C and sum B & D. The issue is that Col A & C
do not contain the same doctors. If Col A & C were the same then it would be
sum b & D.

Thanks

Brad

one method might be to insert a new column c and column F
in Cell C1
=countif(A:A,A1,B:B)+Countif(D:D,A1,E:E)
and in F1 enter
=countif(A:A,D1,B:B++countif(D:D,D1,E:E)

and copy C1 and F1 down as far as you want

"alyzar" wrote:

I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would
like to do is to combine Col A & C and sum B & D. The issue is that Col A & C
do not contain the same doctors. If Col A & C were the same then it would be
sum b & D.

Thanks

Brad

How difficult would it be to make the Drs in A & C allign. Script could be
written to get them to allign.

"alyzar" wrote:

Joel,

The problem is that "col a" and "col c" dont match up. There are more ref
md's in 2006 then 2005. Is there an easier way of combining "a &c" other
than inserting rows to make the name macth up? Hope this is clear for you
Thanks
Brad



"Joel" wrote:

Not sure how your speadsheet is laid out. Each doctor should have his own row

Not
A B C D
Dr. A Dr. A
Dr. B Dr. C
Dr. D Dr. D


Should Be
A B C D
Dr. A Dr. A
Dr. B
Dr. C
Dr. D Dr. D

Leave Blanks if Dr. didn't give referels for certain years. Then the sum
would work properly.

"alyzar" wrote:

I have a list of referring md's for a 2 yr period. In Col A ref md (2005)
Col B #of referrals, Col C ref md (2006) Col D #of Referrals. What i would
like to do is to combine Col A & C and sum B & D. The issue is that Col A & C
do not contain the same doctors. If Col A & C were the same then it would be
sum b & D.

Thanks

Brad