https://bugs.documentfoundation.org/show_bug.cgi?id=115841
Bug ID: 115841
Summary: sumif across multiple sheets using named range not
working
Product: LibreOffice
Version: 5.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dmohin...@yahoo.com
Description:
I have a workbook which works in MS Excel 2013. But not working in LibreOffice.
This workbook has following sheets
1. Summary sheet with contains list of all items to be procured.
2. Multiple sheets for each products being manufactured. One sheet for each
product.
Working of this workbook:-
Each individual product sheet has bill of material which has all the component
used in that product. Each product has many component common to many other
products. I populate all the individual product sheet with required quantity.
Then I have a summary sheet which has list of all components used in all the
products being manufactured. In this sheet requirement of all the components
used in all the products is calculated. Basically sumif across multiple sheets.
The formula used in MS Excel 2013
=IF($J$1<>"YES",SUMPRODUCT(SUMIF(INDIRECT("'"&Products&"'!"&Range),A3,INDIRECT("'"&Products&"'!"&Sum_Range))),"")
where Products, Range, Sum_Range is a named range.
Actual Results:
It is summing a item from only one/first product workbook
Expected Results:
It should sum a item used in all product worksheet
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/61.0.3163.100 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs