conditional calculations

  1. T

    Basic Conditional Probability Problem

    Hello, I'm very new to excel so appreciate this problem may be very basic however i have a list of future expenditures in Column C with a running total at the bottom. In Column D I have whether it has been paid for or not with a simple yes or no. What i want is for when yes is entered into a...
  2. A

    Conditionnal Sum

    Hello, Here is what I have : A B 2 - 4 5 5 - 6 7 What I need to do is a sum of the column A if <>#N/A" and "<>#DIV/0! And In case the cell value B is not blank, replace the value in the corresponding A cell with the B cell value In this case A column sum is 17 the sum I want is 19 Could...
  3. C

    old Excel 2003 help conditional lookup

    I am beating my head against a wall trying to find a solution. Please have mercy. A B C D E Item number, Pricing Level, Cost, Price, Profit 1 A 1.00 2.00 1.00 1 B...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...??

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top