Countifs help please - falling at the third

[HuskyJones]

Hi all
Can you tell me where i'm going wrong here.

I'm trying to get Patient does not equal "General Practice" has a "Wells Score DVT" of 2 or more and has had any imaging from AO, AP, AQ (the patient in green cells)

I can get it as far as =COUNTIFS('Raw Data'!$J:$J,"<>General Practice",'Raw Data'!$AF:$AF,">=2") but as soon as i enter the last bit i go to #VALUE!

=COUNTIFS('Raw Data'!$J:$J,"<>General Practice",'Raw Data'!$AF:$AF,">=2",'Raw Data'!A03:AQ1003,"1")

THANK YOU Hive!!

 

[felixstraube]

Maybe this correction?:
=COUNTIFS('Raw Data'!$J:$J,"<>General Practice",'Raw Data'!$AF:$AF,">=2",'Raw Data'!$AQ:$AQ,"1")

 

[HuskyJones]

Maybe this correction?:
=COUNTIFS('Raw Data'!$J:$J,"<>General Practice",'Raw Data'!$AF:$AF,">=2",'Raw Data'!$AQ:$AQ,"1")

Thanks for quick reply, no doesn't work with $AO3:$AQ1003 or $AQ3:$AQ1003 (ideally need it to count if in any of the three cols)

 

[felixstraube]

You should select ranges that are of the same size.
Like this:

Book1
	H	I	J																						AF											AQ
4	3		General Practice																						1											1
5			Other text 01																						2											0
6			Other text 02																						3											1
7			Other text 03																						4											1
8			Other text 04																						1											0
9			General Practice																						2											0
10			Other text 06																						3											1
11			Other text 07																						4											0
12			Other text 08																						1											1
13			Other text 09																						1											0
Raw Data

Cell Formulas
Range	Formula
H4	H4	=COUNTIFS('Raw Data'!J:J,"<>General Practice", 'Raw Data'!AF:AF, ">=2", 'Raw Data'!AQ:AQ, "1")

Or like this

Book1
	H	I	J																						AF											AQ
4	3		General Practice																						1											1
5			Other text 01																						2											0
6			Other text 02																						3											1
7			Other text 03																						4											1
8			Other text 04																						1											0
9			General Practice																						2											0
10			Other text 06																						3											1
11			Other text 07																						4											0
12			Other text 08																						1											1
13			Other text 09																						1											0
Raw Data

Cell Formulas
Range	Formula
H4	H4	=COUNTIFS('Raw Data'!J3:J100,"<>General Practice", 'Raw Data'!AF3:AF100, ">=2", 'Raw Data'!AQ3:AQ100, "1")

 

[HuskyJones]

You should select ranges that are of the same size.
Like this:

Book1
	H	I	J																						AF											AQ
4	3		General Practice																						1											1
5			Other text 01																						2											0
6			Other text 02																						3											1
7			Other text 03																						4											1
8			Other text 04																						1											0
9			General Practice																						2											0
10			Other text 06																						3											1
11			Other text 07																						4											0
12			Other text 08																						1											1
13			Other text 09																						1											0
Raw Data

Cell Formulas
Range	Formula
H4	H4	=COUNTIFS('Raw Data'!J:J,"<>General Practice", 'Raw Data'!AF:AF, ">=2", 'Raw Data'!AQ:AQ, "1")

Or like this

Book1
	H	I	J																						AF											AQ
4	3		General Practice																						1											1
5			Other text 01																						2											0
6			Other text 02																						3											1
7			Other text 03																						4											1
8			Other text 04																						1											0
9			General Practice																						2											0
10			Other text 06																						3											1
11			Other text 07																						4											0
12			Other text 08																						1											1
13			Other text 09																						1											0
Raw Data

Cell Formulas
Range	Formula
H4	H4	=COUNTIFS('Raw Data'!J3:J100,"<>General Practice", 'Raw Data'!AF3:AF100, ">=2", 'Raw Data'!AQ3:AQ100, "1")

THANK YOU!!! it worked <3

 

[Peter_SSs]

THANK YOU!!! it worked <3

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.