Functions

Using Sumproduct when some of the values are null
I am having a problem using Sumproduct when some of the cells have null values. I will try to describe the problem. Please let me know if you need additional information. Do any of you have any ideas of how I can fix that sumproduct to get it to work? A B C Row ... 24 Mar 2010 23:54

Justify across selection
I found the "center across selection" formatting function but I really need to "justify across selection." Any ideas? -- bfloyd ... 23 Mar 2010 17:12

SUMIFS using a text range
I am still new to Excel 2007. I want to start using SUMIFS for their efficiencies over array formulas. They don’t seem to work the same. I want to sort by Dep and Account and by month. The data comes in TEXT format. I can’t get it to work without converting the TEXT to VALUES. I bring in data and need to sort it li... 28 Mar 2010 21:12

Date Format
A date has been entered in cell E4, 31/03/2010 but has been formatted so as to display as MAR-10. That's okay, that's what I want. I now wish to refer to that cell at B12 using the following - ="Closing Balance at "&E4 However, this displays as Closing Balance at 40268 I think I have to format the date reference 4... 23 Mar 2010 13:41

macro shortcut help
Hello I have a Macro set up in spreadsheets I have made for multiple people. I have set it up so they can paste the info needed in a worksheet and then use the shortcut ctr(a) to run the macro below to delete all rows with lab in it. Sub Find_LAB() Dim rng As Range Dim what As String what = "LA... 23 Mar 2010 16:00

counting function with weekdays only
I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz ... 23 Mar 2010 14:49

Lookup on a combo box
I have a combo box in cell C2, with facility locations in it. In another cell i want to either have an if statement if it matches the name put in an overhead rate or i could do a vlookup and have a hidden table in the sheet. Is there a way to do either of these on a combo box. ... 23 Mar 2010 13:40

How do I create a travel expense report by employee, by campus, b.
Hi I need to create a spreadsheet that tracks travel expenses by employees, and by date that travel to different college campuses ... 23 Mar 2010 20:38

Pivot Table Refresh
I believe there is a way to create a button to refresh multiple pivot tables within the same file, but I can't seem to figure it out. I'm creating a model and would like less sophisticated users to be able to use it. I would therefore like to create a simple button to refresh all pivot tables on the first s... 24 Mar 2010 17:03

date format error in cell
I have one cell that for some reason even though the format is set to general, when i put in say 2007-2011 i get a pop up box that says date format error. the issue is that this is the only cell in the entire column with this issue. this is a file exported out of SAP to Excel with VBA code in the background. the... 23 Mar 2010 11:20