Functions
in [Excel]
|
Totaling text cells Is it possible to autosum the total of cells that contain only text, in a worksheet that contains cells with only text and cells with only numbers? ... 20 May 2010 13:54
Filter by formula Hi max Thks for your help but I tried it today but it don't work. In fact I have two workbooks. One is the database file with a list of informations I have listed previously and the other workbook is the report which is generated by sumproduct to extract informations in the database workbook. Here is a speci... 21 May 2010 07:19
SUMIF division From Sheet 2, I'd like a formula to calculate the following using an array: If Sheet1 Column A = Sheet2 Column A AND If Sheet1 Column K > 0 THEN Divide Sheet1 Column K by Sheet1 Column L Can anyone help? Thanks. Bob ... 20 May 2010 16:08
Reminder - Microsoft Responds to the Evolution of Community Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 22 May 2010 18:13
Overlap graph multiple axis Hi, I am aware of secondary axis. But is it possible to plot more than 2 types of data? So, for example I want to plot over time (so week1, week 2, etc = x-axis). and on the y-axis I want to plot firstly the volume of a particular product sold. Secondly the weekly price it has been sold at, thirdly the margin ... 22 May 2010 08:21
Formulas displayed in cell rather than calculated values? I have this problem come up at randon about once or twice a year. I always have my options set to show formula values in a cell, never the formulas themselves. However, once in a while, when I type in a formula and hit enter, the formula appears in the cell and not the value. Today, I typed a new formula over... 20 May 2010 12:48
HELP PLEASE Re: Totals for month if 2 conditions are met Still need help with this I'm afraid, would it help if I use SUMPRODUCT to match the names in some way? I am using the following in a different sheet. SUMPRODUCT(--(p2e_Advisor_Last_Name="Thompson"),--(p2e_Advisor_First_Name="Rob")) could it be inserted into =SUMPRODUCT(--(Sheet1!A2:A100=A2),--(MONTH(Sheet1!D2:D10... 20 May 2010 07:17
returning a value in a table referencing ranges I have a chart 1 that has a list of ranges and if the number falls with in the range I want the commision value returned to my new work sheet ex: Chart 1 Col A Col B Col C 500 599 50.00 600 699 55.00 if the calculated total on my seperate worksheet A is between 500 599 I want the 50.00... 23 May 2010 02:49
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: Level Item Quantity Cost 1 Chair 1 $39 2 Seat 1 $15 3 Cushion 1 $10 ... 19 May 2010 19:24 |