Countif/s

[PGD15]

Hi im being dumb,

Im trying to do a count if where if the value in range a2:a239 is equal to l26 (separate tab) then I want to know if the value in raneg i2;i239 is greater than f2:f239 count that.

tried : but not working ( i do mean 329 cba to edit all above lol)

COUNTIFS('Contract Data'!$A$2:$A$329,'Company Summary'!$L$26,'Contract Data'!$I$2:$I$329,"='Contract Data'!$F$2:$F$329")

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1									54
2	5					58			35			3
3	4					64			22
4	94					29			92
5	54					31			46
6	63					99			49
7	38					76			47
8	70					14			12
9	54					68			73
10	6					95			10
11	93					8			29
12	97					81			96
13	89					8			87
14	54					82			95
15	65					6			10
16	81					31			26
17	54					88			68
18	54					76			40
19	94					33			27
20	48					78			37
21	33					43			41
22	57					49			17
23	52					37			74
Sheet16

Cell Formulas
Range	Formula
L2	=SUMPRODUCT(--($A$2:$A$23=I1),--($I$2:$I$23>$F$2:$F$23))

 

[PGD15]

ah yeah that makes sense thanks!