I just had the biggest brain fart. I have a worksheet I am trying to copy
all of the data from one to the other using a formula. The work sheet with
the data is called one where the one that I am trying to write a formula to
copy it to is two. When I do sum it makes the name 0. Example below

Thank you

Ex
A B C D
1 0012 Bob Tiffany
2 0026 Brandy Frank
3
4