You'd probably need to add a new column to your data set to distinguish/flag
non continuous from continuous dates cases, and populate this col manually.
Then use sumproduct (instead of sumif) to take care of the multi-criteria
summing.
--
Max
Singapore
---
"Charles S" wrote:
Max - thank you for replying. Just checking about continuous dates - if
Jones took a further 1 day absence in January 2010, I need this to show as
short term only. Is there a formula to cope with this as well?