sumif column index number

  1. oldeirish

    Adding Separate Columns of a Table To Obtain 7% of Total

    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 $...
  2. A

    SUMIF on column defined in formula

    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...
  3. J

    48 worksheets to summarize

    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...
  4. H

    SUMIF formula with Sum_Range based on column index number

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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top