COUNT / SUMPRODUCT with multiple criteria (wildcard "*")

Hello,

As you can see in the attached document, I try to find a way to count the days and the offs for a specific person from a monthly calendar.
When two or more people have an "off" or a "wfh day" i cant think of a way to automatically count these days.

The SUMPRODUCT function doesn't work with wildcards -> =SUMPRODUCT(($A$4:$A$24="Off")*($B$4:$H$24="*"&$D$27&"8"))
When there is only one person I could use this formula -> =IF($D$27="";"Choose a name in cell D27";SUMPRODUCT(($A$4:$A$24="WfH")*($B$4:$H$24=$D$27)))


Please check the attached excel file. Monthly Program.xlsx


Thank you in advance

How about

Formula:

Please Login or Register  to view this content.

It works. Thank you!

Glad to help & thanks for the feedback.