Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which formula to use?
Hello
I have a grid of data, down the left is 2 columns for product item and description, along the top are months. I need a formula function to search along the top to find the correct month, then search down the 1st column to find a product match, then search down the 2nd column to find a description match. The intersection of the correct row(s) and column being the value i require. There may be several returns matching the same criteria, so the results need adding together. Previously (xl2003) we used a sum(if array but it is slowing the calculations right down. Now (xl2007) I have looked into the new sumifs and getpivotdata but can't get any sense out of either. I can do a custom function, but at the moment would rather keep it standard. Any ideas Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |