Reputation: 1
I am trying to create a formula in Excel that automatically calculates the total value from a range based on a number of criteria across multiple sheets in a workbook. I am working in two different sheets:
Here is a link to view the workbook: https://docs.google.com/spreadsheets/d/1vf-wcaVokKr7apkoibM7Vx-q2MYJkmLlDl8wsKW8TVo/edit?usp=sharing
Sheet 1 contains all my input data:
Sheet 2 is the client facing report that contains:
In the Total Values column of Sheet 2 I want to automatically sum:
Sheet 1 Forecast $ based on Sheet 1 Description = Sheet 2 Category but only for the date range where (Sheet 1 start date is (>= Sheet 2 beginning of week date range and <= Sheet 2 end of week date range)
The calculation needs to be applied across 4 different categories and 52 different start and end date weeks in Sheet 2.
Is this possible?
Upvotes: 0
Views: 177
Reputation: 69
My rating is not high enough to add this as a comment, but this site is good for creating a table for SO.
https://senseful.github.io/web-tools/text-table/
Upvotes: 0