I Think Sumproduct

[djfatboyfats]

I need a formula that will count how many callbacks are overdue, example i want to count the dates then the critiria then find out how many callbacks are overdue, so the formula is looking for anything before todays date that has not yet been called

Thanks

FBF

[john_mc]

Hi,

here is one i did recently - similiar lines - but as you haven't explained where your data is/what field to check, you'll have to customise:

=SUMPRODUCT((Your Sheet, Your Cell Range= first is/isn't callback criteria)*(Your Sheet, Your Cell Range= second what is the date criteria)*(Your Sheet, Your Cell Range > time criteria))

Note that the time criteria will be a decimal. Best thing is format/cell/time and then choose a format. Type in your time (e.g 5:00 for 5am) then change the format to number. This then shows the decimal you'll need to enter in your formula.

my exact formula was:
=SUMPRODUCT((Agent Availability Report July '!$A$3:$A$25000=C3)*(Agent Availability Report July '!$C$3:$C$25000="Login")*(Agent Availability Report July '!$F$3:$F$25000>0.711805555))

and was used to see who was still logged in after 5.05pm.

This should get you started, but it's hard to say without more info.

John Mc