Computers
Computer Parts
Custom PC Builder
DIY/ Maker
{$smarty.capture.menu}
Activity
Categories
Discussions
Computers
Computer Parts
Custom PC Builder
DIY/ Maker
How to count Filled Cells in Microsoft Excel - Micro Center
<main> <article class="userContent"> <p>This article will show you how to count filled cells in Microsoft Excel.</p><p>Sometimes in Excel, when there is a column filled with many textual entries, it is useful to know how many entries actually exist. This article describes how to use a formula to count the number of filled cells in Excel.</p><p>Here is how to do this:</p><p><br></p><p>1. With Microsoft Excel open on your PC, select the cell that the result will be stored in and then click on the <strong>Formulas</strong> tab.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://us.v-cdn.net/6031946/uploads/GNV7EU4LAZX0/image.png" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://us.v-cdn.net/6031946/uploads/GNV7EU4LAZX0/image.png" alt="image.png" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>2. Click on <strong>More Functions.</strong></p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://us.v-cdn.net/6031946/uploads/COAZVA9LOTHU/image.png" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://us.v-cdn.net/6031946/uploads/COAZVA9LOTHU/image.png" alt="image.png" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>3. Click on <strong>Statistical</strong>.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://us.v-cdn.net/6031946/uploads/QG49SAPTL6QD/image.png" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://us.v-cdn.net/6031946/uploads/QG49SAPTL6QD/image.png" alt="image.png" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>4. Scroll down through the list of options and click on <strong>COUNTA</strong>.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://us.v-cdn.net/6031946/uploads/VGEEAYDSYYBF/image.png" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://us.v-cdn.net/6031946/uploads/VGEEAYDSYYBF/image.png" alt="image.png" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>5. Click on the <strong>square</strong> next to the Value 1 text box.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://www.microcenter.com/Content/Content%20Graphic/Images/5377_HOW5005581B-005.gif" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://www.microcenter.com/Content/Content%20Graphic/Images/5377_HOW5005581B-005.gif" alt="5377_HOW5005581B-005.gif" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>6. Click at the top of the range to be counted. Hold down the mouse button and drag to the bottom of the range. Release the mouse button and press the square in the <strong>Function Arguments</strong> box.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://www.microcenter.com/Content/Content%20Graphic/Images/5378_HOW5005581B-006.gif" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://www.microcenter.com/Content/Content%20Graphic/Images/5378_HOW5005581B-006.gif" alt="5378_HOW5005581B-006.gif" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>7. Click on <strong>OK</strong>.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://us.v-cdn.net/6031946/uploads/DO8PE0GPV0U5/image.png" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://us.v-cdn.net/6031946/uploads/DO8PE0GPV0U5/image.png" alt="image.png" height="180" width="320" loading="lazy"></img></a> </div> </div> <p></p><p><br></p><p>8. All filled in cells in the range have now been counted and the amount is listed in the specified cell in your spreadsheet.</p><div class="embedExternal embedImage display-large float-none"> <div class="embedExternal-content"> <a class="embedImage-link" href="https://www.microcenter.com/Content/Content%20Graphic/Images/5380_HOW5005581B-008.gif" rel="nofollow noreferrer noopener ugc" target="_blank"> <img class="embedImage-img" src="https://www.microcenter.com/Content/Content%20Graphic/Images/5380_HOW5005581B-008.gif" alt="5380_HOW5005581B-008.gif" height="180" width="320" loading="lazy"></img></a> </div> </div> <p><br></p> </article> </main>