# Fomula required to calculate and summarise qty's between a start and finish date

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

• Good Morning, I am really scratching my head here with a formula I need to summarise numbers of resource demand per day from a schedule with start and finish dates. I have attached an example excel document - I hope someone can help me?.

In table 1 I have a schedule to Resource, Start Date and finish date then qty. In table 2 I simply want it to create running totals per day - I hope it pretty self explanatory?.

## Files

• Hello Freddy,

Try:

=SUMIFS(E\$4:E\$6,C\$4:C\$6,"<="&H4,D\$4:D\$6,">="&H4)

Regards,

Haseeb Avarakkan

__________________________________

"Feedback is the breakfast of champions"

• The most efficient way is to use a PivotTable. You can use SUMIF formulas.

SUMIF Function

Whichever solution that you use converting the Data to a Table will make it easier

Overview of Excel tables

• Hello Freddy,

Try:

=SUMIFS(E\$4:E\$6,C\$4:C\$6,"<="&H4,D\$4:D\$6,">="&H4)

Absolutely bang on Haseeb - appreciate that so much.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!