Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Problem with SUMIF
In a worksheet I have one tab that contains detail information. I filter the
detail information twice and create a new worksheet a copy-paste the 2 different sorts. Then I return to the original worksheet, to a different tab, and insert a SUMIF that references the newly created worksheet (Book1). The process and SUMIF worked fine in Excel 2003 version. It also works fine if I reference between 2 tabs in the same original worksheet. (Note: If I don't create the new worksheet and just filter on the detail tab, the SUMIF does not recognize the filter and pulls all the info from the detail tab. That is why I create the new worksheet with the 2 filtered data tabs.) The formula in the original workbook looks like this: SUMIF("'[Book1.xls]Sheet1'!$H:$H",B3,"'[Book1.xls]Sheet1'!$J:$J") Since the original worksheet will be shared with users in a lower version, although I am working in Excel 2007, I saved both worksheets to a lower version (Excel 97-2003) This seems to be a very simple and common SUMIF function. The error returned is: "The formula you typed contains an error" It sometimes highlights the B3 reference. Thank you for assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel SUMIF function problem | Excel Worksheet Functions | |||
Excel 2007 and OLAP problem | Setting up and Configuration of Excel | |||
Excel 2007 Bug or other problem | Excel Discussion (Misc queries) | |||
Excel 2007 VBA problem | Excel Discussion (Misc queries) |