Bug ID: 115841
Summary: sumif across multiple sheets using named range not
Version: 22.214.171.124 release
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
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
where Products, Range, Sum_Range is a named range.
It is summing a item from only one/first product workbook
It should sum a item used in all product worksheet
User Profile Reset: No
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