Hi all, I have a spreadsheet with about 20 columns of data, 3 of which are long-winded array formulas. I have some conditional formats and simple IF functions...

I am currently trying to copy a formula down for a total of 734 rows and across several columns. For some strange reason it stops at 641 rows. Once I drag...

I am trying to figure out a way to quickly generate a gross payroll number without the aid of a 'helper' row, which won't work this situation. I have about...

Hello all, I was trying to use the Match function in a VBA module (I hate VBA). Match was failing unexpectedly. I evenetually tracked down one issue (using...

I have a spreadsheet with multiple worksheets. I need one sheet called Customer Lookup to pull data from another sheet called Liability Policy Expiration,...

Hello, I'm having a problem with combining strings, basically I will have two cells with names that will be combined so I did the =a1 & " " & a2 assuming...

I am looking for the value when Loan amount is $670,000 with 640 FICO and LTV 76 and that should give me 3.000 LTV 0 70.01 75.01 80.01 85.01 90.01 Loan...

Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS in my workbook. One works great, the other does not. They are virtually the...

I'm trying to convert a text file with multiple rows (10) of repeated data. The "Text to Columns" function in Excel can only sort one row. Is there a way in...

I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc...

1. Countif with multiple criteria. I have tried sumproduct as follows... =SUMPRODUCT(('Jan 06'!A:A="B")*('Jan 06'!G:G="TRUE")) but this gives me a result as...

I have a large worksheet and I'm trying to pull some specific information out of it, and I'm not getting the numbers I expected- so I think there is something...

I'm trying to perform a count based on two columns and two conditions. I've searched the forum and found several options but can't get any of them to work....

Hi I am trying to create a combination function. I want to first sum specific cells in a column and then if the sum is a certain value, I want the cell to...

This box is in my way when using @sum, but I am unable to find how to hide it. how do you hide SUM(number1,,...

Am totaling scores for each judge for a contest, and each entry is judged in 3 categories. Need to sum the remaining scores, by tossing out that judges...

Hey Guys: Can one of yuz take a look at this formula related to a 5 Year Automotive depreciation factor? Here it is: 21,000 Initial cost =A12 2,100 Salvage...

I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours

I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y...

Hello, I'm badly in need of some help with an excel formula. Essentially I need to check to see if the value of C7 is "Y" and if so for the formula then to...