conditional calculations

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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