| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum multiple colums of data
I'm trying to write a formula that will sum all columns by quarter, so it
will sum Jan-Mar by looking up "Q1" in row 1. Any thoughts are greatly appreciated. Thanks A B C D E F G 1 Q1 Q1 Q1 Q2 Q2 Q2 2 Jan Feb Mar Apr May Jun 3 #1 ## ## ## ## ## ## 4 #2 ## ## ## ## ## ## 5 #3 ## ## ## ## ## ## 6 #4 ## ## ## ## ## ## 7 #5 ## ## ## ## ## ## 8 #6 ## ## ## ## ## ## |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP for multiple colums | Excel Worksheet Functions | |||
| Using sumproduct to sum multiple colums | Excel Discussion (Misc queries) | |||
| Formating excel multiple paragraphs and colums using one source of data | Charts and Charting in Excel | |||
| lock multiple rows and colums ? | Excel Discussion (Misc queries) | |||
| sumif issues over multiple colums | Excel Worksheet Functions | |||
Threaded Mode
