Count on vertical and hrizontal data

Hello,

I have employees name in column a and column b,c and rest have dates on row B
On row one above the dates, week numnber is mentioned. (e.g. 1x1,1x2,1x3,1x4,2x1 and etc)

I need to count the days the ee was present for that week


1X1 1X1 1X1 1X1 1X1 1X1 1X1 1X2 1X2 1X2 1X2 1X2 1X2
Name 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan
abc WO LH EL P P P WO WO P P P P P
def WO LH P P P P WO WO P P P P P
ghi WO LH P P P P WO WO P P P P P

some where below the data is a format
name 1x1 1x2 1x3
abc 3 2 4


I need a formula that will show the above total "p" (present) total for that 1x1, 1x2 weeks which extends to 3 months

Pleas let me know of you need any more information

data in csv format
,1X1,1X1,1X1,1X1,1X1,1X1,1X1,1X2,1X2,1X2,1X2,1X2,1X2
Name,1-Jan,2-Jan,3-Jan,4-Jan,5-Jan,6-Jan,7-Jan,8-Jan,9-Jan,10-Jan,11-Jan,12-Jan,13-Jan
abc,WO,LH,EL,P,P,P,WO,WO,P,P,P,P,P
def,WO,LH,P,P,P,P,WO,WO,P,P,P,P,P
ghi,WO,LH,P,P,P,P,WO,WO,P,P,P,P,P

Please post a workbook for us - do not include real names

To do this
Click REPLY,GO ADVANCED, scroll down to MANAGE ATTACHMENTS etc


ManageAttachments3.jpg