Ahh, I just realized you posted in .worksheet.functions as well. Please
don't multi-post. You've got a response there from Herbert with a link to a
sample book. You should follow through & feedback to him there.

Over here, well .. think I've already given your post/issue whatever help I
can.

(You don't have to press the "Yes" button to this response,
since you seem to have an aversion to clicking that button)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,200, Files: 354, Subscribers: 53
xdemechanik
---
"Ms. D" wrote in message
...
Ok - I'm a slow learner

In Sheet 7 is where the formula needs to be the data is in Wks 1-6 but I'm
doing one Wks at a time

Wks 1 looks like this

A B C D
Atlanta Chicago New York
XX 1234 9202 333
YY 4930 331 2893
ZZ 393 3930 3030

Wks 2 looks like this

A B C D
Atlanta Chicago New York
XX 6789 3456 333
AA 2030 39 90
BB 796 989 5930
ZZ 806 7777 3030

Wks 7 has the results

Wks 1 Wks 2
so on ...
A B C D E
Atlanta Atlanta Chicago Chicago
XX 1234 6789 9202 3456
AA 0 2030 0 39

YY 4930 0 331 0
BB 0 796 0 989

ZZ 393 806 3930 7777

I'm formatting Wks 7 one column at a time basis on the previous Wks 1-6

Thanks in advance for your help!!!!!!