I have a worksheet that counts the number of days a person works each month. Everything was fine until I was asked to separate out the days a person only made emails or phone calls and no F2F (Face to Face) calls. The formula for Days worked was easy I just concatenated the person name with date and sorted and got the days worked. I have no idea how to get days that were not face to face.
I would appreciate any help you could provide.
The formula result I would like is in the column called Days no F2F
[TABLE="width: 543"]
<tbody>[TR]
[TD]Assigned[/TD]
[TD]Subject[/TD]
[TD]Date[/TD]
[TD]Combined[/TD]
[TD]Days Worked[/TD]
[TD]Days no F2F[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/2/2018[/TD]
[TD]Person 143161[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD]Person 143164[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD]Person 143164[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/12/2018[/TD]
[TD]Person 143171[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/12/2018[/TD]
[TD]Person 143171[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/19/2018[/TD]
[TD]Person 143178[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/19/2018[/TD]
[TD]Person 143178[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
I would appreciate any help you could provide.
The formula result I would like is in the column called Days no F2F
[TABLE="width: 543"]
<tbody>[TR]
[TD]Assigned[/TD]
[TD]Subject[/TD]
[TD]Date[/TD]
[TD]Combined[/TD]
[TD]Days Worked[/TD]
[TD]Days no F2F[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD]Person 143160[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/2/2018[/TD]
[TD]Person 143161[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD]Person 143164[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD]Person 143164[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/12/2018[/TD]
[TD]Person 143171[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/12/2018[/TD]
[TD]Person 143171[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/14/2018[/TD]
[TD]Person 143173[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/15/2018[/TD]
[TD]Person 143174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]F2F[/TD]
[TD="align: right"]3/16/2018[/TD]
[TD]Person 143175[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]Phone[/TD]
[TD="align: right"]3/19/2018[/TD]
[TD]Person 143178[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Person 1[/TD]
[TD]email[/TD]
[TD="align: right"]3/19/2018[/TD]
[TD]Person 143178[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]