sumifs formula using date ranges as criteria

[jbrown021286]

TECH HOURS WORKSHEET 2.0 tester.xlsx
	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	AH	AI	AJ	AK	AL	AM	AN	AO
1	Tech Hours																																						6-Jan	15-Jan
2			01FEB24	02FEB24	03FEB24	04FEB24	05FEB24	06FEB24	07FEB24	08FEB24	09FEB24	10FEB24	11FEB24	12FEB24	13FEB24	14FEB24	15FEB24	16FEB24	17FEB24	18FEB24	19FEB24	20FEB24	21FEB24	22FEB24	23FEB24	24FEB24	25FEB24	26FEB24	27FEB24	28FEB24	29FEB24			total hours	working days	level	Class
3			1-Jan	2-Jan	3-Jan	4-Jan	5-Jan	6-Jan	7-Jan	8-Jan	9-Jan	10-Jan	11-Jan	12-Jan	13-Jan	14-Jan	15-Jan	16-Jan	17-Jan	18-Jan	19-Jan	20-Jan	21-Jan	22-Jan	23-Jan	24-Jan	25-Jan	26-Jan	27-Jan	28-Jan	29-Jan	30-Jan	31-Jan						0
4	Jeff	101502	1.1	9.9	22.5	0	8.4	22	14.2	0.3	17.5	13.9	0	7.4	8	4.6	4.8	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	134.6	12	4	M
5	Justin	101549	2	20	4	0	6.5	10.4	5.2	5.2	3	13.8	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	70.1	9	4	M
Jan

Cell Formulas
Range	Formula
AM3	AM3	=COUNTIFS(C3:AG3,">=AM1",C3:AG3,"<=AN1",C4:AG4,">.9")

im not sure why my formula in am3 isnt working. i need to count the cells in row 4 that are more than .9 and fall in the date range in am1 and an1. any help would be appreciated.

 

[Phuoc]

Try change to:

=COUNTIFS(C3:AG3,">="&AM1,C3:AG3,"<="&AN1,C4:AG4,">.9")