Good afternoon all, I have been searching for a while and can't seem to get the right answer. This is what I have. B5 26658 C5 0.6803 D5 31920 E5 0.7649 F5 24798 G5 0.6972 I am trying to return the number from B5, D5, F5 and so on, for my sheet using something like this, for example, in cell A25, my formula is =B5 or =SUM(B14:B20) in a few other cases, then I copy it straight down to A50, so A26 returns D5, A27 returns F5 and so on, but I can't figure it out. I figure whatever the answer is I can modify to fix both formulas.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula for counting every other column
- Thread starter Vengeant
- Start date
