COUNTIF formula

[bakerd]

Does anyone have an inkling why when I use the COUNTIF formula in one cell to count specific items in a single column range of cells and it works, but when I create a second & third COUNTIF formula in the cells directly below the first and they each count specific items in the same single column range of cells as the first formula that it only displays the formula and not the count. I am even using the "Formulas" tab and starting the COUNTIF action from the selection under the "Statistical" portion of the "Formulas" tab.
Here is the first COUNTIF formula: =COUNTIF(I2:I67,"BDSP2012&2014") This formula resides in cell I92
Here is the second COUNTIF formula: =COUNTIF(I2:I67,"BDSP2014") This formula resides in cell I93
Here is the third COUNTIF formula: =COUNTIF(I2:I67,"ACAD2014") This formula resides in cell I94

As I said all 3 formulas are in cells one above the other in the same column "I" as the column range indicates.

 

[Comfy]

Make sure the other two cells aren't formatted as TEXT.

Select I93 format as General, press OK, press F2 and then Enter.

Repeat for I94

 

[bakerd]

AWESOME, AWESOME, AWESOME
Thank you so much, this did the trick. I am 65 and I can now say you can teach new tricks to old dogs!

 

[Comfy]

AWESOME, AWESOME, AWESOME
Thank you so much, this did the trick. I am 65 and I can now say you can teach new tricks to old dogs!

You're very welcome.