Need count formula

Question

Need Present & WO count in B4/C4 from below list against each name without adding any extra cell. I am unable to find formula for the same.
Name	Present	WO
Emily
Paige
Ramesh
Lucky
Roshan
Tinku
Name	01-Feb	02-Feb	03-Feb	04-Feb	05-Feb	06-Feb	07-Feb	08-Feb	09-Feb	10-Feb	11-Feb
Emily	Present	WO	Present	Present	Present	WO	Present	Present	Present	WO	Present
Paige	Present	Present	WO	Present	WO	Present	WO	Present	WO	Present	Present
Ramesh	Present	Present	Present	WO	Present	Present	Present	WO	Present	Present	Present
Lucky	Present	Present	WO	Present	Present	WO	Present	Present	WO	Present	Present
Roshan	WO	Present	Present	Present	Present	Present	WO	Present	Present	WO	Present
Tinku	WO	Present	Present	Present	Present	WO	Present	Present	Present	Present	WO
Emily	WO	Present	Present	WO	WO	Present	Present	Present	Present	WO	Present
Paige	WO	Present	WO	Present	Present	Present	Present	Present	WO	Present	Present
Ramesh	Present	WO	Present	Present	Present	Present	Present	WO	Present	WO	Present
Lucky	Present	Present	WO	Present	Present	Present	WO	Present	Present	Present	WO
Roshan	Present	Present	Present	WO	Present	WO	Present	Present	Present	WO	Present
Tinku	Present	Present	Present	Present	WO	Present	Present	Present	WO	Present	Present
Ramesh	Present	Present	Present	WO	Present	Present	Present	WO	Present	Present	Present

Answer 1

I think this is very difficult to solve with formulas or maybe impossible. The reason is that your data shows the same name in multiple rows.

A possible way is to load the data into Power Query and unpivot the day columns, create a Pivot Table and now you can count anything pretty simple.

Give me a sign if you're interested. EDIT: Just to demonstrate the benefits:

Andreas.

Answer 2

One way would be to use the MMULT function as demonstrated in the picture below:

=SUM(MMULT(--TRANSPOSE($A$13:$A$25=$A5),--($B$13:$L$25=B$4)))

Enter the formula in B5. Copy down and across.

Note: The red and green shading was done to check the numbers for Emily.