<div>
=COUNT(F1:F99360, 538) gives me 99361 which is wrong, it give me 99361 no matter what value I'm looking for.<br />
<br />
=COUNT(F1:F99360, 540) gives me 99362, etc.
</div>


=COUNT(F1:F99360, 538) gives me 99361 which is wrong, it give me 99361 no matter what value I'm looking for.

=COUNT(F1:F99360, 540) gives me 99362, etc.

<div>
it is COUNTIF not COUNT<br />
<br />
<br />
Duncan
</div>


<div>
Please take a look the Excel tutorial at this site if have time<br />
<a href="http://www.techonthenet.com/excel/formulas/countif.php" rel="ugc">http://www.techonthenet.com/excel/formulas/countif.php</a><br />
<br />
Duncan
</div>


Please take a look the Excel tutorial at this site if have time
http://www.techonthenet.com/excel/formulas/countif.php [http://www.techonthenet.com/excel/formulas/countif.php]

Duncan

<div>
Sorry for the delay I've been out for a week.
</div>


Sorry for the delay I've been out for a week.

<div>
<div class="content wysiwyg-content">
I have a spreadsheet with 90,000 rows and 10 columns. I need to find out how many of the cells contain a specific value. Let's say 538. How many cells have 538 their cell. I've tried to sort but the it's so unwieldy the program craps out. Sorting hangs and never recovers.<br />
<br />
Any quick and simple method to extract this one bit of info?
</div>
</div>


I have a spreadsheet with 90,000 rows and 10 columns. I need to find out how many of the cells contain a specific value. Let's say 538. How many cells have 538 their cell. I've tried to sort but the it's so unwieldy the program craps out. Sorting hangs and never recovers.

Any quick and simple method to extract this one bit of info?

Finding how many in a Excel spreadsheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.