ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formulas for counting (https://www.excelbanter.com/excel-discussion-misc-queries/171747-re-formulas-counting.html)

Gord Dibben

formulas for counting
 
The cell may have been formatted as text.

Format to General then F2 + ENTER.


Gord Dibben MS Excel MVP


On Fri, 4 Jan 2008 11:11:00 -0800, donna
wrote:

I am trying to use the countif formula to count on an excell spread sheet, I
dont have numbers in the colum I have X, I have used the following formula
=countif(a1:A12,"X") but when I hit the enter button or the control shift
enter button nothing is adding, all it shows is the formula I but in. Please
Help!




All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com