Unable to execute formula on a range of cells that are also formulas

[Crysizzle]

The title is less than clear, my apologies.

I'm doing totals/ responses.
I have a row of cells that is actually a "IF" formula that looks to another worksheet. "IF" the target cell on the other worksheet is a certain value (text) a certain numeric value is returned. This works flawlessly

At the end of that row I have another formula where I am looking to "countif" the numbers(calculated above) are >= another number =COUNTIF(D2:I2,">=3")

everything comes up 0 - I know this is because the range i am providing is actually cells that contain formulas, for the love of everything good and holy I cannot remember what to do to make this work. I can manually put in numbers in a row and use the same formula and tada get an answer.

I've tried number, general, custom - no formats seem to work.

thoughts?

[Norie]

Sorry, but that's wrong.

COUNTIF will work if the values are the results of formulas or have been entered manually.

Of course that depends on what the values are.

Can you post an example of the IF formula?

[Crysizzle]

=IF(Data!H2="Value1","1",IF(Data!H2="Value2","2",IF(Data!H2="Value3","3",IF(Data!H2="Value4","4"))))

[Crysizzle]

the IF part works fine the CountIF is failing.

[Norie]

Your IF formula is returning text values, your COUNTIF is looking for numeric values.

Try removing the quotes around 1,2,3 etc.

[Crysizzle]

well. that was it. I'm a twit.

Thank you !!!!