**Need a sumif formula** *Summary*: I have the following spreadsheet where the information is automatically pulled from a database. It sums the total by Month but then it sums it twice b...

**Need a sum formula for employee account codes** *Summary*: I am trying to create a sum formula that will search within a table and sum the total number of hours for each employees by month by account code. Eve...

**[Solved] Help with IF Function** *Summary*: Need help adding a function to a formula in Excel 2010. Formula is located in D25. Current Formula: =IF(OR($G25>0,$H25>0,$I25>0,$J25>0,$K25>0,$L25>0,$...

**[Solved] IF statement using OR** *Summary*: I am attempting to enter an =IF(OR.. statement to provide a "1" in the output cell if any one of the conditions are true, and a blank cell if none of ...

**[Solved] Adding the if statement i always get zero (ms excel 2007)** *Summary*: HOW CAN I PROBABLY GET THE SUM OF THE 2 IF STATEMENT? MY IF STATEMENTS: =IF(A1=90,"1","0") MEANS THE STATEMENT SHOWS 1 IF IT IS CORRECT "0" IF WRONG...

**Excel: looking for sum of cells associated with drop downs** *Summary*: Hi I am trying to create a spreadsheet/workbook to record financials for a volunteer organization. Was hoping to have a sheet that fed a cashflow (to ...

**Date formula in excel 2007** *Summary*: Hi, how to add a sum for a date lets say 2/3/2012, i want a formula which will autopopulate the date automatically to 2/08/2012 that is 2/03/2012 + 5 ...

**[Solved] Sum cells with three numbers in each cell seperated by a /** *Summary*: Hello. I need to sum cells with three different numbers in the each cell. The numbers are seperated by a /. For example A1 = 4/3/1 and A2 = 3/2/1. I n...

**[Solved] The sum for looking up various numbers across two sheets** *Summary*: I have a sheet with patient identifiable numbers in it - I want to see if these patients are in another sheet with their identifiable numbers - What i...

**[Solved] Excell column addition** *Summary*: Hi, I want to set a formula by which every cell of a particular column will be the sum of values of some previous columns of the corresponding columns...

**fn return range of cells that satisfy a condn** *Summary*: I have some data in excel as below. Date Head Amount 1.04.11 A1 200 1.04.11 A2 140 1.04.11 A1 20 2.04.11 A1 ...

**Wrong data type Error on SUM Formula** *Summary*: I'm setting up a spread sheet to keep track of fire calls that volunteer firefighters respond to. We require that they make a certain % of calls per q...

**Excel: Add Data Based On Month** *Summary*: I have the following formula im having trouble with Im hoping someone can help me out A B D ...

**vlookup, sum (2 columns ref)** *Summary*: I'm new to formulas..umm.. is the following output possible? BASIS: code length balance 1234 3.5 3 1234 3.7 4 1235 3.5 8 1235 ...

**Sum of components used** *Summary*: I have an excel workbook containing 2 lists: 1. An array of components for each assembly configuration (essentially a bill of materials). Components a...