SumIf across columns instead of rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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+AD6+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.
.

Relevant Pages

  • Re: minus numbers problem
    ... Access is not a spreadsheet on steroids, and you will NOT get the benefit of ... Wrap your sums in the Abs function to turn the sum to a positive ... Query: the query has sum in the total row and they are all set as ... are not displaying minus and they seem to be identical in everyway. ...
    (microsoft.public.access.gettingstarted)
  • RE: My IF function is saying something is false when it is true...
    ... You may be getting rounding errors on the decimal places. ... A couple of methods to solve this is to round off using the round function ... works accurately for other parts of the spreadsheet) involves three columns: ... have to simple SUM functions at the base of the Cost Budgeted and Actual Cost ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Sumproduct dvision
    ... I am using another spreadsheet as my source. ... "John C" wrote: ... I need the sum of volume x rate. ... of Amount / Sum of Volume) will be equal to Sum of Amount. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Sumproduct dvision
    ... "MrRJ" wrote: ... I am using another spreadsheet as my source. ... "John C" wrote: ... I need the sum of volume x rate. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: summing data from columns
    ... I'm trying to sum and count my data. ... idea to do these calculations in the table - rather, ... You're "committing spreadsheet upon a table", ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.gettingstarted)