Hi, i have a formula here that doesn't work =SUM(IF((TB!$B$2:$B$4133=$A2)*(TB!$D$2:$D$4133="M"),TB!$I$2:$I$4133)) What i was after is to get the total in the...

I have a spreadsheet with 50,000 + rows and columns A through DF. I would like to look at each row as a record and return only rows where all the columns...

Hello, I have a formula here and I don't understand why it doesn't work. The situation is such. I have a cell A1 that has a specfic date in it. If this...

Hi, I've got the following information on a spreasheet: A B C 1 Asia Measurement 0.64 2 Goal 2.0 The Cell...

I want to create a sheet that I can collate data gathered from the net for release dates of books, dvd's etc... I will not be doing this on a regular...

I would like to change the backgound color of a cell to yellow, based on the value of that cell being greater than 60. This should apply to all cells in a...

I have several worksheets with the same formula over and over. I need to make sure that the precedents are correct. Each worksheet has about 600 lines. ...

Newbie he I would like to select a column (A1:L1) based on the data in cell M1. My data range is A2:L20. The data in A1:L1 starts w/1000 and steps up 500...

I am looking for a formula to take data from worksheet 1 column F based on week number in column B and sum it in worksheet 2 column E. catch is that there...

I want to increase an amount ($1,000) over a number of periods (52 weeks) so that it will achieve a 40% increase at the end to $1,400. I would like a formula...

I have 3 columns. Customer# Margin $ Average Order size The table is sorted to show customers with descending Average order size. I am trying to get the sum of...

I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL...

Is it possible to pick and choose what entries can be selected for making a set of labels? If so...explain in detail as I am a Novice Excel User...thanks in...

Hi I have posted this erroneously in excel programming. Sorry for posting in 2 separte groups. I am using the illustration below to explain my problem. ...

My worksheet name is BU300, I want the value of a specific cell, in the same worksheet, to be BU300, without me having to type it. Is there a formula to do...

I have filters on and I'm using the SUM to add a group of numbers. It seems that excel automatically adds adjacent cells that I have hidden(I'm guessing...

Hi All, I updated data validations in one of my workbook(5000 rows have been using in that particulat sheet with validation rules for all the cells in this...

Can someone please advise, how can I extract a date from a cell which contains a date and a text. FEDERAL HOME LN BKS CONS BD 3%0 Callable...

How do I create a single formula to either round up or down the result of my formula to the nearest "9"? i.e. 843 = 839 845 = 849 etc., etc. Thanks, Jack

I'm making a workbook that has 1 Worksheet which summarizes the data contained on the other 10 worksheets. I'm using formulas to reference the value on the 10...