Functions

SUMIF based on cell shading
Is it possible to write a SUMIF formula based on cell shading? If so, how? I want to add up cells based on the shading of the cell. Thanks. ... 17 Feb 2010 17:57

How do i calculate the percentage to compare two different years
... 17 Feb 2010 16:48

New free mail add-in for Excel/Outlook 2007-2010
Posted to more then one newsgroup FYI Today I upload a new version of my Excel Mail add-in for Outlook. If you want to test it you can find it here http://www.rondebruin.nl/mail/add-in.htm Let me know if you have problems -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm ... 17 Feb 2010 15:39

sorting multiple columns
I have multiple addresses on a work sheet. I need to have all the same zip code # together. How do I sort them by zip code so right name and address ends up with right zip code ... 17 Feb 2010 16:48

Countif across multiple sheets - sheet NAME issue?
Hi there, I am using the following formula (see below), but wondering if the sheetnames I enter have to be in the EXACT order that there are in the spreadsheet? =SUMPRODUCT(COUNTIF(INDIRECT("'"&BA2:BA151&"'!e50"),"x")) where BA2:BA151 is a range housing the relevant sheetnames in separate cells ... AND e50 ... 18 Feb 2010 07:14

highlighting different line in a cell
How do I highlight different lines within the same cell two different colors? ... 17 Feb 2010 15:39

CUBEMEMBER
Does anyone know if you can use a wildcard with the cubemember function, and if so, how? I am trying to pick up all product IDs that start with KRLMJ129* (ie, KRLMJ129arj, KRLMJ129lik, KRLMJ129pwr, etc.). Is this possible? I have tried adding the * at the end of the ID, but it doesn't work. Using Excel 2... 17 Feb 2010 14:31

why do print range erase in Excel when import data from access
I have a workbook set up in Excel 2007 that serves as a template for data dumps from Access 2007. In the Excel template, I have set all the print titles and print ranges for the various worksheets that need to be printed. These worksheets use vlookup formulas to grab the data from Access. When I export my da... 17 Feb 2010 15:39

Conditional Formatting for entire row
I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather ... 17 Feb 2010 15:39

HELP!! Formula with different conditions
Suppose your 15 is in A1. This will give you 3.5 in one column: =MAX(0,MIN(11,A1)-7.5) and this will give you 4 in another column: =MAX(0,A1-11) and will cope with other values as expected. Hope this helps. Pete On Feb 17, 5:36 pm, Teri <T...(a)discussions.microsoft.com> wrote: Hi there.  I'm hopi... 17 Feb 2010 13:24