Sum of overdues dates with conditions

[elfrider]

Hi all,
I'm looking to return some values from a column which is full of dates ($H:$H), being both historic and in the future:

1) A value for the sum of the days that today() is greater than the column of dates (i.e sum of overdue days), but only where the specific date has been passed (i.e ignore from calculation if it isn't overdue/in the future).

2) As above, but also based on the value in a different column ($B:$B) which contains the region name (four regions) - in other words four different values, each one being the sum of the overdue dates for the particular region.

3) As above, but the average days overdue rather than the sum of them.

Thanks in advance for your help.
Nathan

 

[RoryA]

It would be simpler and more efficient if you can add a column that subtracts the dates from TODAY(). Is that an option?