Elizabeth_Otike
New Member
- Joined
- Jan 31, 2021
- Messages
- 2
- Office Version
- 2013
- Platform
- MacOS
I have 9 worksheets. Each has a column for amount and a column for product category. There are 3 product category.
I want to sum the total amounts by their product category across multiple work sheet. Previously, when it was a single sheet I used this formula- sumifs(sheet1!B:B,sheet1!C:C,”ProductA”)
How do I replicate this across multiple work sheets?
Thanks.
I want to sum the total amounts by their product category across multiple work sheet. Previously, when it was a single sheet I used this formula- sumifs(sheet1!B:B,sheet1!C:C,”ProductA”)
How do I replicate this across multiple work sheets?
Thanks.