| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you write an excel formula to sum data in every second cell
I have a list of numbers all in one column and I want to be able to type in a
formula that will SUM the numbers in every second cell only, without having to click on each cell individually. This is how I do it now, =sum(a1+a3+a5+a7+a9+....etc). Is there a formula that will tell excel to do this automattically? If so can you tell me how to do it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Threaded Mode
