CODEWITHSUNDEEP
excelexcel-formula
user5362080
user5362080

Reputation: 1

Sum value based on multiple criteria including name and > and < date range

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

Answers (1)

Paul
Paul

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

Related Questions