COUNTIF formula

bakerd

Board Regular
Joined
Jun 23, 2003
Messages
53
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.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,386
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

Board Regular
Joined
Jun 23, 2003
Messages
53
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!
 

Forum statistics

Threads
1,143,654
Messages
5,720,101
Members
422,266
Latest member
Mattyw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top