Executive Managing Member

Bill Golden

<div>
Lightning FAST and Perfect! Thanks...
</div>


<div>
<div class="content wysiwyg-content">
In Excel, I have a column of numbers, &nbsp;F5 through F150. Each line has Yes or No in Column E. I want to take a total in cell F151 of all cells (F5 through F150) in which a Yes appears in the corresponding cell in Column E.
</div>
</div>


In Excel, I have a column of numbers,  F5 through F150. Each line has Yes or No in Column E. I want to take a total in cell F151 of all cells (F5 through F150) in which a Yes appears in the corresponding cell in Column E.

Totalling a column of cells based on Yes/No value in corresponding cells.

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.