Use SUMIFS on Multiple Columns using BYCOL?

We have a BOM template that needs to accommodate multiple end items. On the Purchased items break down we need to list all purchased items then consolidate the list of purchased items (Rows) and main...