ExcelBanter - pull data for a company with data in diff cells multiple wrkshts

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - pull data for a company with data in diff cells multiple wrkshts (https://www.excelbanter.com/excel-worksheet-functions/76065-pull-data-company-data-diff-cells-multiple-wrkshts.html)

kcoachbiggs

pull data for a company with data in diff cells multiple wrkshts

How can I pull data for Company X if they have totals in different cells on
multiple worksheets into a summary sheet....
Ex: Delta Company has 42 in cell C23 on Worksheet A
and Delta Company has 53 in cell b32 on Worksheet B

How can I add these two cells together in a summary worksheet and receive
the total of 85 in Worksheet C for Delta Company?

All times are GMT +1. The time now is 07:12 PM.