Countifs with multiple criterias

[wrkforce1]

I'm trying to get a total count of how many times a tag was used, but the table export I have isn't the best to work with. I'm not able to just add in two criterias for countifs like I typically do. I'm thinking I would need to do a countif+index match, any one can find the easiest way to do this?

The tags are listed horizontally after the scores. I'm able to get the total number of times each tag was used, but I want to know how many times the tag was used with a score # criteria.

I tried =countifs($D:$AF,B2,C:C,"<=4") but getting an error. The intention was to see how many times the tag in cell B2 (a cell on another sheet where I have a running list of the tags listed) with the score of 1-4 were used.

Sample of the table I'm using:

 

[DanteAmor]

Assuming your data on Sheet1 like this:

varios 14sep2020.xlsm
	A	B	C	D	E	F	G	H
1	date	score
2	01-sep	1		GB Plus - up	SWAT	SWAT	SWAT	SWAT
3	02-sep	2		SWAT	GB Plus	SWAT	SWAT	SWAT
4	03-sep	3		SWAT	SWAT	GB Plus	SWAT	SWAT
5	04-sep	4		SWAT	SWAT	SWAT	T2 PH	SWAT
6	05-sep	5		SWAT	SWAT	SWAT	SWAT	SWAT
7	06-sep	6		SWAT	SWAT	GB Plus	SWAT	SWAT
8	07-sep	7		SWAT	SWAT	SWAT	SWAT	SWAT
9	08-sep	3		SWAT	GB Plus - up	SWAT	SWAT	SWAT
10	09-sep	4		SWAT	SWAT	SWAT	SWAT	GB Plus
11	10-sep	5		GB Plus	SWAT	SWAT	SWAT	SWAT
12	11-sep	6		SWAT	SWAT	SWAT	SWAT	GB Plus
Sheet1

Put the following formula on sheet2 in cell C2 and copy down:

varios 14sep2020.xlsm
	A	B	C
1
2		GB Plus	3
3		GB Plus - up	2
4
Sheet2

Cell Formulas
Range	Formula
C2:C3	C2	=SUMPRODUCT((Sheet1!$D$2:$AF$1000=Sheet2!B2)*(Sheet1!$B$2:$B$1000<=4))

 

[wrkforce1]

@DanteAmor - Thanks so much!! That worked! I didn't know I could use sumproduct like that, but this was so much easier.

If I'm looking for total count between two numbers, ie. scores between 5 -7, how would I write that using sumproduct.

 

[DanteAmor]

If I'm looking for total count between two numbers, ie. scores between 5 -

=SUMPRODUCT((Sheet1!$D$2:$AF$1000=Sheet2!B2)*(Sheet1!$B$2:$B$1000>=5)*(Sheet1!$B$2:$B$1000<=7))