Countifs problem!

[krispatterson]

This is doing my head in... & I know this is going to be a missing bracket or comma or something...


data = [TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01/01/17[/TD]
[TD]chris[/TD]
[TD]01/01/17[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]06/01/17[/TD]
[TD]geoff[/TD]
[TD]08/01/17[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]12/01/17[/TD]
[TD]bob[/TD]
[TD]15/01/17[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]12/02/17[/TD]
[TD]chris[/TD]
[TD]22/01/17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



why doesn't this formula work?
=COUNTIFS($A:$A,">="&c1,$A:$A,"<"&c2),'[HOTS Spreadsheet.xlsx]HOTs'!$b:$b,"chris"




Let me know, thanks

 

[jorismoerings]

Are you sure you copied the actual formula you're using?
Cause the example will evaluate into an error every time by cause of the closing bracket after C2.

try this: =COUNTIFS($A:$A,">="&c1,$A:$A,"<"&c2,'[HOTS Spreadsheet.xlsx]HOTs'!$b:$b,"chris")

 

[krispatterson]

Are you sure you copied the actual formula you're using?
Cause the example will evaluate into an error every time by cause of the closing bracket after C2.

try this: =COUNTIFS($A:$A,">="&c1,$A:$A,"<"&c2,'[HOTS Spreadsheet.xlsx]HOTs'!$b:$b,"chris")

boom - thanks!! I knew it'd be something basic, just couldn't find the problem!