| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i add numbers in nonadjacent cells?
-- Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add numbers in nonadjacent cells?
Any pattern like every third row or something? Also are there numbers in the
cells in-between, if not you can use =SUM(Range) since sum will ignore text, otherwise use =SUM(A1, B5, S2 etc) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Bob" wrote in message ... -- Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| How do I merge 2 cells to 1 when contents are numbers | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
Linear Mode
