Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using MS Vista and Excel 2007. My question is how do I sum even columns
in a spreadsheet? My spreadsheet is set up in the following manner: 11/7/08 11/14/08 11/24/08 Col A1 Col B1 Col C1 Col D1 Col E1 Col F1 Col G1...etc Sold to 20 $20.00 10 $10.00 5 $5.00 In column B1, D1 and F1 I have a number and in column C1, E1 and G1 I have an associated cost. The spreadsheet can require expansion to the right to column EZ. My question is how do I sum Column B1, D1...EZ1 in a predetermined cell (FA1)? I cannont use the sum function as it has a limit on the number of individually selected cells that can be summed. Is there a way to tell it to sum starting at B1 every other cell to the right stopping at EZ1? Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Setting up and Configuration of Excel | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |