=IF(COUNTIF for one range and multiple criteria

[BrandyLeaAnn]

Hi all!
I am trying to convert numbers in multiple columns to a value in words. I am using the =IF(COUNTIF(range,criteria),"value if true","value if false") function and able to make it work with only one criteria, but having trouble returning a value when using multiple criteria. This is what I am using so far, but I also want a criteria of "11", "12", "13", & "14" to return "Hispanic or Latino" if true and "" blank if false. I tried the COUNTIFS function, but maybe I didn't add my criteria correctly...

 

[jtakw]

Hi,

Not sure what you mean, may be this:

Book3.xlsx
	N	O	P	Q	R	S	T
2	1	2	11				Hispanic or Latino
Sheet1033

Cell Formulas
Range	Formula
T2	T2	=IF(SUM(COUNTIF(N2:P2,{1,11,12,13,14})),"Hispanic or Latino","")

 

[BrandyLeaAnn]

Hi,

Not sure what you mean, may be this:

Book3.xlsx
	N	O	P	Q	R	S	T
2	1	2	11				Hispanic or Latino
Sheet1033

Cell Formulas
Range	Formula
T2	T2	=IF(SUM(COUNTIF(N2:P2,{1,11,12,13,14})),"Hispanic or Latino","")

jtakw that worked perfectly!!!
Thanks so much!

 

[jtakw]

You're welcome, thanks for the feedback.