Counting data per person in a table

Hello everyone,

I have to create a table which will find exact name and surname from the column with names and surnames and then count how many times specified text occured within row where this name and surname is. I also have to do this per month. The range of months is of course dynamic (30,31,28/29days).

In the first data table you can see I have names and surnames in column B, then I have a table with schedule with shifts marked as D,N,ML,DOTs with numbers. I only want to count how many DOT8/DOT9/DOT12 Name and surname has and then multiply accordingly to number next to, so "*8","*9","*12" per month and then SUM it to get totals. Important thing is that in the main table, so Data table the positions of names and surnames will be changing later on, they might be in lower or higher row.

The end table can't be on the same sheet as data table.

I'm a bit confused by your description and sheet. Perhaps a sample of the output would help? Here is what confuses me,

I have a table with schedule with shifts marked as D,N,ML,DOTs with numbers AND then multiply accordingly to number next to, so "*8","*9","*12" per month and then SUM it to get totals.

I can get you a total by adjusting your "data table" and "the table I need" tabs with some tweaks, for example replace the values in row 2 of the data table with actual dates such as 4/1/2018 (formatted any way you want) then dragged right. Then also change the dates in row 1 of "the table I need" from April to 4/1/2018 (formatted as mmm-yy so it looks like Apr-18) then this sumproduct will return the counts of DOT8 (for example) for Paul John...
=SUMPRODUCT(('Data table'!$B$4:$B$8=$A3)*('Data table'!$D$4:$CP$8=B$2)*('Data table'!$D$2:$CP$2>=B$1)*('Data table'!$D$2:$CP$2<=EOMONTH(B$1,0)))
But what I don't get is how you want the Ds handled for Paul. For example, for April Paul has 5 Ds, 5 Ns, 1 H and no DOTs. So what should his results be?

I would also suggest using real dates, that way you can use excel's built-in date functions.

I would also suggest swinging your table around, so you have dates going down, and names across.

I tried Sambo's suggested formula, and it worked for me, too

The problem with what you posted is that you DON'T have dates. You have text in row 1 and numbers in row 2 of the data table. For example, the #1 in cell D2 of the data table isn't recognized by excel as a date. The word April cell S1 is just text, excel doesn't recognize it as a date. To leave it as it is and try to write a formula for excel to do a combination of S1 and D2 then S1 and E2 and S1 and F2 (etc.) so excel would convert them to dates would be very convoluted. Maybe it can be done with VBA.
Good luck.