New 2007 Sumifs formula - is there a new multiple criteria vlookup
The new sumifs formula is fantastic. Is there a new multiple criteria vlookup
( as I want to return text) in 2007?. Eg does not need to be an array formula, can reference columns not ranges etc just like the new sumifs. I already use {INDEX('Net Sales'!$O$2:$O$35000,MATCH(1,('Net Sales'!$Q$2:$Q$35000=D2)*('Net Sales'!$S$2:$S$35000=E2),0)))} Heres hoping there is. Thanks Craig |
New 2007 Sumifs formula - is there a new multiple criteria vlookup
Nope, no new lookup functions in Excel 2007.
There are 5 new functions that would be useful to the average user: AVERAGEIF AVERAGEIFS COUNTIFS IFERROR SUMIFS -- Biff Microsoft Excel MVP "westy" wrote in message ... The new sumifs formula is fantastic. Is there a new multiple criteria vlookup ( as I want to return text) in 2007?. Eg does not need to be an array formula, can reference columns not ranges etc just like the new sumifs. I already use {INDEX('Net Sales'!$O$2:$O$35000,MATCH(1,('Net Sales'!$Q$2:$Q$35000=D2)*('Net Sales'!$S$2:$S$35000=E2),0)))} Heres hoping there is. Thanks Craig |
New 2007 Sumifs formula - is there a new multiple criteria vlookup
Hi,
The answer is no as TV said. However, there are a lot of useful improvements to the functions area in addition to the 5 core functions and 8 cube functions: Feature 2003 2007 Array References 65535 rows, 255 col Limit removed Maximum length of a formula 1,024 8,192 Number of levels of formula nesting 7 64 Number of function arguments 30 255 Number of dependencies for a single cell that are trackable for partical recalc 8,192 Limit removed Number of areas with dependencies trackable for partical recalc 65,536 Limit removed Number of array formulas that can refer to another worksheet 65,536 Limit removed Number of categories availble for custom functions 32 255 Number of rows in a column refered to by an array formula 65,335 Limit removed The 93 function in the Analysis ToolPak have been incorporated into Excel Add-in in Excel There are other related feature enhancements. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "westy" wrote: The new sumifs formula is fantastic. Is there a new multiple criteria vlookup ( as I want to return text) in 2007?. Eg does not need to be an array formula, can reference columns not ranges etc just like the new sumifs. I already use {INDEX('Net Sales'!$O$2:$O$35000,MATCH(1,('Net Sales'!$Q$2:$Q$35000=D2)*('Net Sales'!$S$2:$S$35000=E2),0)))} Heres hoping there is. Thanks Craig |
All times are GMT +1. The time now is 11:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com