Calculate total value up to yesterdays date

[chally3]

Good morning all,
Ive searched for a answer for my query but alas cannot seem to find one, can someone help please.
I have a sales order due data export that I put into a simple pivot table. What I am trying to do is show a total value for orders overdue.
I thought this would be simple enough!

Row 4 (columns A,B,C are order/part info) Column D onward is dates "orders are due to ship".
Row 5 are daily £ totals 'due to ship'

All I wish to show is a total value up to yesterdays date in cell "B2" (or even another work sheet) -effectively total overdue value.


Any help much appreciated, unfortunately we currently only have this info as a 'paper report'!

Thank you

 

[FormR]

Hi, you could try something like this:

=SUMIFS(D5:ZZ5,D4:ZZ4,"<"&TODAY())

 

[chally3]

Possibly the quickest reply ever, kudos and thank you.

 

[chally3]

Hi, you could try something like this:

=SUMIFS(D5:ZZ5,D4:ZZ4,"<"&TODAY())

Just 1 more question, how could I adapt the forumula to be 2 days prior to today? Thank you

 

[chally3]

Thank you, just 1 more question - How could I change the formula to be today minus 2 days (ie overdue 2 days ago). Thank you

 

[MARK858]

.........

=SUMIFS(D5:ZZ5,D4:ZZ4,"<"&TODAY()-2)