| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding noncontiguous cells
Hi, I have a huge spreadsheet with over 250 columns. There are over 40
columns with the heading "Sales" and I have to add the numbers under each of the "Sales" headings together. Does anyone know the best way to do this? Clicking on every cell is timeconsuming, but even trying that doesn't work because apparently there is a limit to how much Excel will accept in a SUM formulas of that nature. Is there a way to do this using SUMIF to specify adding only the numbers under the "Sales" headings or any other way? Thanks in advance for any help or suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells witht the same name | Excel Discussion (Misc queries) | |||
| Adding up multiple cells | Excel Worksheet Functions | |||
| Adding cells with the same color, sub works but function doesnt | Excel Discussion (Misc queries) | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Threaded Mode
