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