Functions

Summing multi-level bill of material
All, I have a multi-level bill of material and I want to create a function that will sum it properly without having to sum up each level manually. Here is an example: Item ... 21 May 2010 04:05

SumProduct using Date Range
I need to sum a values using multiple criteria and a date range. Example - I need to sum the total amount of all investors that have an "N" in the n/e column, are in a specified region, in a specified fund, and are between the dates of 2/1/2010 through 3/1/10. Can't seem to get this to work? Any help is grea... 19 May 2010 17:10

SUMPRODUCT with date range
I need help with a sumproduct formula that will sum with three difference types of criteria and also use a date range? Any suggestions? ... 19 May 2010 17:10

In Excel, conditional format (font red) referencing another ce
"SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------... 4 Jun 2010 17:00

pivot table
how do I do a pivot table with data that is on multiple worksheets? ... 19 May 2010 17:10

Filter formula
HI I have a database with repeated informations as listed below and is increasing daily Nat Firm Name SPAIN VIAJES EL CORTE INGLES SPAIN VIAJES EL CORTE INGLES SPAIN VIAJES EL CORTE INGLES GREECE AMEX INTERNATIONAL- HOLLAND GERMANY AIRTOURS INTERNATIONAL-GERMAN ITALY DERTOUR GMBH & CO. KG UNITED KINGDOM ... 19 May 2010 20:31

Sumproduct formula
I have the following columns in a table. Customer # Product # Invoice # Pack Size For every Product shipped to a customer we want to charge a lump sum fees for the number of boxes. I want to see the fees show up only in one line where the identical Invoice # and Customer # ends. Is it prudent to use Sumpro... 23 May 2010 07:04

Ytd formula
I have a database in a workbook which is increasing on a daily basis. the column consiste of e.g Date country T.operators Rm Type Qty Amount etc I have a report separately which is link to the workbook by formulas and is controlled by a combo box when we changed the period or date. Is there a formula whic... 19 May 2010 14:55

Paste Special function and Hyperlinks
I am creating a 'Parent' Workbook which lists a whole load of documents which are hyperlinked to PDF files of the actual document. I need to create a few 'Child' workbooks which will list only a few of the documents from the parent with the hyperlinks. I wanted to link them so when a document is updated I wil... 19 May 2010 14:55

Excel Code
I am trying to put together a spread sheet that will allow me to type a specific letter and a 9 digit code will appear once I enter the letter. ... 19 May 2010 12:42