conditional calculations

  1. S

    Fantasy football calculators

    Newbie here, I apologize if this has been covered and/or is a stupid question: I'm trying to set up a sheet that will allow me to enter statistics from NFL games and generate the fantasy points earned by each player. This is not hard on the surface, but the problem is calculating the points...
  2. B

    selectively mutiplying mulitple worksheets

    I have 10 worksheets all with entirely different workings and I get a table of adjustment factors as the end result from each worksheet. An example of the resultant adjustment factor tables from 3 worksheets. <TABLE style="WIDTH: 218pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...
  3. X

    conditional lookup macro looping

    hi, in cell S8 of sheet2 im trying to do a calculation in sheet1... i have values in sheet 1 in column I, I2:I42 i have dates in sheet 1 in column J, J2:J42 i have values in sheet 1 in column K, K2:K42 in sheet2... i have values in sheet 2 in column M, P, and G and dates in column E all of...
  4. S

    Workbook Control

    HI, I have multiple workbooks (Excel 2007) feeding into a master worksheet to create my company's financial models. I am trying to create a control of sorts that I could use on any of the sheets (each representing a department) to convert the values in various ranges to 0 so that I can model...
  5. B

    Adding n number of cells

    Hi I need a formula that sums up the values of n quantity of cells determined by the value of another cell? Example: In Column A I have Row #- value 1 - 5 2 - 3 3 - 4 4 - 6 5 - 5 in cell B1 i have a value of 4 in cell B2 I want a formula that adds the first (cells b1 value) cells in column a...
  6. J

    Std if

    Can someone help me out? I'm comparing various sets of data in a table based on certain conditions. I must include these conditions so I can exclude data based on dates and how I categorize clients based on tier. I am using this formula, =STDEV(IF(March[Go...
  7. H

    NEED HELP - SUM Using VBA

    I have a spreadsheet where all the data are kept and are pulling in certain data to different spreadsheet(in the same wb) where dates are in by the columns. For example if customer "A" has data for 4/11/10(column B) and 4/24/10(column C) then all the #s that are for 4/11/10 goes to column B and...
  8. H

    Count empty cells if the previous cell is populated and timestamp

    Hello, I have a spreadsheet that i collaborate with multiple users on my office network. column A is for date, B for order number, C for Tracking number. I was wondering if there is a way where i can put the order numbers on daily basis and automatically show the time and date i made the entry...
  9. S

    Compare values in adjacent rows in one column, summing values in the same rows in a different column

    Hello, everyone. I have a spreadsheet with columns listing "Customer Name," "Extended Price," and "Date." Each customer purchased specific line items during a certain time period. The customer's name (unique for each customer) is "Customer Name," the total value of each item purchased is...
  10. P

    Include cell in calcuation based on other cell value

    The workbook I'm creating needs to be able to be used in Excel 2003 (I am developing using 2007) - I know the answer to my question in 2007 is to use SUMIFS I have a Banking Forecast spreadsheet - At the beginning of the month, I know what payments have to be made each day of the that month...
  11. Y

    Logic test

    Hi there, I need some help with an IF formula I'm trying to use to tabulate questionnaire results. I have a "header" row where I have the question, and then below that row are "sub" rows where I placed what the correct response are, yes (cell C3), or no (cell C4). Under that section I have...
  12. C

    Conditional calculation in Excel

    I have four possible combinations that can happen.. Based on the combination, I need to multiply different coulmns and put it in a cell. Could you please send me the syntax please...??

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top