Hi,
I required a formula help (Sum product or sumifs with Indirect function) to prepare a summary section wise separately by referring the "Ref Number",
values to be return automatically once entered Ref Number in cells Column A of summary sheet with including related descriptions against ref numbers.
Sample workbook enclosed for reference.
Thanks in advance,
Bookmarks