Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif function help
Wondering if anyone could help me with these functions
When I use the sumif functions and offset functions on one workbook linking to another workbook it normally works and would give me a value. However after I saved the workbooks and closed them down and reopen the one that contains the functions the formulas will give me #VALUE rather than a numeric result until I open the workbook where the sumif data is linking to How can I overcome this problem? Please help Thanks Vivi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif function help
Use SUMPRODUCT instead of SUMIF, as that works fine with closed workbooks.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vivi" wrote in message ... Wondering if anyone could help me with these functions When I use the sumif functions and offset functions on one workbook linking to another workbook it normally works and would give me a value. However after I saved the workbooks and closed them down and reopen the one that contains the functions the formulas will give me #VALUE rather than a numeric result until I open the workbook where the sumif data is linking to How can I overcome this problem? Please help Thanks Vivi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
SUMIF function | Excel Worksheet Functions |