| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf across columns instead of rows
to I have a set of metrics that are laid out horizontally in a spreadsheet,
and I need to sum up every other column. Is there a way to use SumIf or a similar formula so I don't have type each cell into a Sum function? Currently my formula is =SUM(B6+D6+F6+H6+J6+L6+N6+P6+R6+T6+V6+X6+Z6+AB6+AD 6+AF6+AH6+AJ6+AL6+AN6+AP6) which is very error prone and manual to update when I add a column. Each column to be added has a column header of "Total" so I tried =sumif(B5:AQ5,"TOTAL",B6:AQ6) but it returns zero. I also tried sumif(A:AQ,mod(column(),2)=0,B6:AQ6) and got zero also. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
| SUMIF with rows and columns | Excel Worksheet Functions | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Threaded Mode
