sumif column index number

How to calculate 7% of tax from 3 different columns? Can I input all my data then convert to a table? <tbody> New Subtotal Credit Over Due Fee Column1 HST 7% $ 365.00 $ 5.00 $...

Hello, I have a sheet with column headings as the month (Jan, Feb, Mar, etc) and data for each month in the rows beneath. See below: Type 1/1/2011 2/1/2011 3/1/2011 a 5.6 5.3 5 b 2.1 4.2 6.3 c 3.5 8.1 12.7 a 6.1 2.3 -1.5 b 5.5 4.1 2.7 c 5.4 6.1 6.8 a 5.3 9.1 12.9 b 5.2 10.4 15.6 c 5.1 7.3...

So far, I have been able to create formulas to track $ by employee and total by contract; however, tracking unbilled hours (my final goal) has proven to be a challenge. The first two summaries draw the information from one worksheet; whereas, the unbilled data come from many (eventually 48...

Following is a summarized example of my data and what I am trying to accomplish. [Column A] contains a list of account numbers. [Column B] contains current balances, [column C] contains balances from one month ago, [column D] contains balances from two months ago. Within the same spreadsheet...