Countifs based on multiple criteria

[Ava19]

Hi All,

Could you guys please help me on writing a formula to countifs based on the following criteria : 1) by position 2) How many "D" and 3) from the range of the date between x and y ?

Thanks All...

 

[DanteAmor]

Hi and welcome

Try:

varios 25abr2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	Position		week 9			Week10							Week11
2			01-mar	02-mar	03-mar	04-mar	05-mar	06-mar	07-mar	08-mar	09-mar	10-mar	11-mar	12-mar	13-mar	14-mar	15-mar	16-mar	17-mar	18-mar	19-mar	20-mar	21-mar	22-mar	23-mar	24-mar	25-mar	26-mar	27-mar	28-mar	29-mar	30-mar	31-mar
3	2nd Officer
4	1st Officer								D				D
5	1st Engineer		D		D	D
6	1st Engineer																										D	D
7
8
9
10
11
12	From Date		01-mar		To Date			31-mar
13
14
15		D	DD
16	1st Engineer	5
17	1st Officer	2
Hoja4

Cell Formulas
Range	Formula
B16:B17	B16	=SUMPRODUCT(($A$3:$A$10=$A16)*($C$2:$AG$2>=$C$12)*($C$2:$AG$2<=$H$12)*($C$3:$AG$10=B$15))