<div>
That's what I love about Excel, many ways to do the same thing.
</div>


That's what I love about Excel, many ways to do the same thing.

<div>
Pleased to help. COUNTA has the advantage of allowing several non-contiguous ranges to be added.
</div>


Pleased to help. COUNTA has the advantage of allowing several non-contiguous ranges to be added.

<div>
<div class="content wysiwyg-content">
excel 2010<br />
windows 10<br />
<br />
I have a workbook with a worksheet with several columns &nbsp; A-I &nbsp; WITH HEADERS<br />
<br />
What I need:<br />
Is there a way to count the number of cells filled in for each column and give me a total ?<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


excel 2010
windows 10

I have a workbook with a worksheet with several columns   A-I   WITH HEADERS

What I need:
Is there a way to count the number of cells filled in for each column and give me a total ?

Thanks
fordraiders

Counting number of cells filled in for several columns

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.