double formula to return one result?

[gebo84]

I have a spreadsheet that is used to input incoming requests by date. a new row for each new requests received. in the same sheet in the last column i have some metrics that calculate how quickly the requests are dealt with etc.

i have a data collection sheet on a separate tab to collate the date and report on.

the data collection sheet is broken up into months Jan-Dec.

I need a formula that will look at the dates (in column B) and return a sum that is in column AA

column AA is a simple formula that that lets me see if we have responded to a request within the lead time and returns a number which represents days. a negative number will show we have responded quicker than the lead time and a positive number is how many days over the lead time we have gone.

The sum i need is the total requests below Zero for that month

is something like this possible? i imagine it will be a combination of two formulas but i cant seem to get it working

Thanks in advance

 

[gebo84]

its ok ive got it! thanks for your help