I have a very large worksheet (100 Rows By 1000 Columns). In every other column (say A, C, E, etc.) I have data in numerical format (i. e., accounting with no decimal places or dollar signs). In adjacent columns (i. e., B, D, F, etc.) I have data in percentage format. What I would like to do is sum all the non-percentage cells in a row in the first empty cell on the far right, and in the cell next to it, all the % cells. Any ideas for a shortcut?
Thanks in advance.