Formula for COUNTIFS Exact Match in Range of Multiple Columns

[igorteo]

Hello.
I'm trying to find appropriate formula to count exact text in multiple columns where the criteria is the date range (between 2 dates). I have tried with =COUNTIFS(A2:A25,A32,C1:X25,">="&B30,C1:X25,"<="&B31) and the result is #VALUE! .
It is counting fine if the criteria range is in one column, but I need a variables.

Thank you,

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

P​

Q​

R​

S​

T​

U​

V​

W​

X​

SITE

LOCATION

IPR 1

DATE COMP

IPR 2

DATE COMP

IPR 3

DATE COMP

IPR 4

DATE COMP

IPR 5

DATE COMP

IPR 6

DATE COMP

IPR 7

DATE COMP

IPR 8

DATE COMP

IPR 9

DATE COMP

IPR 10

DATE COMP

IPR 11

DATE COMP

NLC

NLC WARDAK

P

1-Aug-19

P

7-Oct-19

P

13-Oct-19

P

22-Sep-19

P

30-Sep-19

NLC

NTB WARDAK

P

2-Oct-19

P

2-Oct-19

NLC

NLC WARDAK

P

1-Aug-19

P

P

1-Sep-19

P

16-Sep-19

P

21-Sep-19

P

30-Sep-19

RMC 1

NTB WARDAK

9-Oct-19

5-Aug-19

P

30-Sep-19

P

15-Sep-19

P

19-Sep-19

P

30-Sep-19

RMC 2

NTB WARDAK

10-Sep-19

P

16-Sep-19

P

5-Sep-19

P

3-Oct-19

RMC 3

NTB WARDAK

P

16-Sep-19

P

14-Sep-19

RMC 4

NLC WARDAK

P

5-Sep-19

6-Aug-19

P

17-Aug-19

P

14-Sep-19

P

7-Sep-19

P

2-Oct-19

NLC

5-Oct-19

1-Sep-19

NLC

5-Aug-19

25-Aug-19

NLC

5-Oct-19

RMC 8

7-Aug-19

RMC 9

RMC 10

5-Aug-19

NLC

9-Aug-19

15-Aug-19

NLC

RMC 7

12-Aug-19

NLC

6-Aug-19

5-Oct-19

NLC

RMC 6

5-Oct-19

12-Aug-19

NLC

6-Aug-19

NLC

5-Aug-19

RMC 5

NLC

NLC

7-Aug-19

8/1/2019

9/1/2019

10/1/2019

8/31/2019

9/31/2019

10/31/2019

NLC

#VALUE!

RMC

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, any sample data would be easier to work with if you investigated the tool linked in my signature block below.

Does this, copied across & down, do what you want? If not, which answers are wrong, what should they be and why?
Note that my dates are in d/m/y format.

Book1
	A	B	C	D
30		1/08/2019	1/09/2019	1/10/2019
31		31/08/2019	30/09/2019	31/10/2019
32	NLC	10	7	7
33	RMC	0	0	0
Sheet2 (2)

Cell Formulas
Range	Formula
B32:D33	B32	=SUMPRODUCT(($A$2:$A$25=$A32)*($C$2:$X$25>=B$30)*($C$2:$X$25<=B$31))

 

[igorteo]

Thank you so so much!!!

The Formula works just fine !!

 

[Peter_SSs]

Thank you so so much!!!

The Formula works just fine !!

You're welcome. Thanks for the follow-up.