COUNTIFS? INDEX? MATCH? I just cant get this to work!

[jreese159]

Good morning all.
I am not all that savvy with excel and am attempting to create a form that will auto fill from another spreadsheet when given a few criteria.
On the column header is dates from the first of a month to the end. On the Y axis are names. In the data range are letters denoting different things.
For example there will be columns for March 1, 2019 thru March 31, 2019 and a row for John Doe. I need to return the number of cells with the letter b for John Doe in the columns ranging from March 8, 2019 thru march 14, 2019.

The spreadsheet is standardized and I cannot change the layout.

Here is what I have attempted.

=COUNTIFS(INDEX('sheet 1'!A1:Z20,MATCH(A15,'sheet1'!A4:A20,0),MATCH(G15,'sheet1'!B1:Z1,1)),"b")

 

[Fluff]

How about

Excel 2013/2016
	A	B
1	Peter Davy
2	08/03/2019
3	14/03/2019	2
4	b
Sheet2

Cell Formulas
Range	Formula
B3	=SUMPRODUCT((Sheet1!A2:A8=A1)*(Sheet1!B1:AF1>=A2)*(Sheet1!B1:AF1<=A3)*(Sheet1!B2:AF8=A4))

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		01/03/2019	02/03/2019	03/03/2019	04/03/2019	05/03/2019	06/03/2019	07/03/2019	08/03/2019	09/03/2019	10/03/2019	11/03/2019	12/03/2019	13/03/2019	14/03/2019	15/03/2019
2	Tom Pearce	s	n	p	h	h	u	a	t	v	s	b	k	w	u	j
3	Bill Brewer	n	t	b	p	m	h	q	q	g	h	v	v	p	z	x
4	Jan Stewer	c	z	r	a	o	c	c	u	h	b	h	j	h	y	z
5	Peter Gurney	k	k	s	i	q	f	e	p	c	l	x	g	u	j	h
6	Peter Davy	o	s	x	v	a	o	x	b	r	b	n	m	j	k	h
7	Dan'l Whiddon	j	m	e	m	g	q	o	e	y	r	n	k	c	u	l
8	Harry Hawke	b	c	i	d	a	n	r	o	v	c	e	r	l	j	d
Sheet1