krispatterson
Board Regular
- Joined
- Apr 28, 2017
- Messages
- 51
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


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

Last edited: