Can you help with a formula? |
I need a Count of records |
where (Column A) (Participant) = #1, #2, or #4 |
and (Column B) (Jobs)) = #1 |
and (Column C) (First Date) is not null |
and (Column D) (Second Date) is null |
and (Column E) (Received Award) ≠1 |
and (Column) (Entry Date) <= the end of the reporting period |
and (Column D) (Exit Date) >= the first date of the reporting period |
or (Column F) (Exit Date) is null)) |