i have this scenario where i wanted to count the number of days an agent was present on the summary field with two criteria
[TABLE="width: 500"]
<tbody>[TR]
[TD]Teams
[/TD]
[TD]Emloyee
[/TD]
[TD]1Aug
[/TD]
[TD]2nd Aug
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]mark
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]zack
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[/TR]
</tbody>[/TABLE]
There are two validation field somewhere on the sheet itself with the list having the names of teams and the dates, so as and when you select those, the count of either absent or present should list out accordingly on the summary tab. The conditions here are teams and dates. So as per the conditions, the number of agents present orabsent for the respective team should list out automatically with consideringthe dates as well.
This is urgent, please help
[TABLE="width: 500"]
<tbody>[TR]
[TD]Teams
[/TD]
[TD]Emloyee
[/TD]
[TD]1Aug
[/TD]
[TD]2nd Aug
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]mark
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]zack
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[/TR]
</tbody>[/TABLE]
There are two validation field somewhere on the sheet itself with the list having the names of teams and the dates, so as and when you select those, the count of either absent or present should list out accordingly on the summary tab. The conditions here are teams and dates. So as per the conditions, the number of agents present orabsent for the respective team should list out automatically with consideringthe dates as well.
This is urgent, please help
