Ok, I've been using Excel for 15 years and this is killing me! This is the problem:
1. I have multiple copied worksheets in my work book
2. In the initial worksheet I use functions such as count, sum, average and they all work just fine.
3. When I copy them into another worsheet in the same workbook they stop working!!!! For instance:
a1 = 4
a2 = 8
a3 = sum(a1,a2)
In the intial worksheet it yields 12. In the copied worksheets it yields 0! My only clue is that when I press f2 then f9 while highlighting 'a1' in the sum equation it registers 4 in the initial worksheet, and "4" (in quotes) in the copied worksheets. Is this some kind of strange formatting issue?
I'd jump out my window but unfortunately I work only on the 2nd floor and would probably just maim myself. Any help would me much appreciated!
Thanks,
Loosenut
1. I have multiple copied worksheets in my work book
2. In the initial worksheet I use functions such as count, sum, average and they all work just fine.
3. When I copy them into another worsheet in the same workbook they stop working!!!! For instance:
a1 = 4
a2 = 8
a3 = sum(a1,a2)
In the intial worksheet it yields 12. In the copied worksheets it yields 0! My only clue is that when I press f2 then f9 while highlighting 'a1' in the sum equation it registers 4 in the initial worksheet, and "4" (in quotes) in the copied worksheets. Is this some kind of strange formatting issue?
I'd jump out my window but unfortunately I work only on the 2nd floor and would probably just maim myself. Any help would me much appreciated!
Thanks,
Loosenut