<div>
You make it look too easy. &nbsp;Thanks for your help!
</div>


You make it look too easy.  Thanks for your help!

<div>
If you have the time, I have the points:<br />
<br />
<a href="https://www.experts-exchange.com/questions/27546923/Spreadsheet-for-billable-time-tracking.html" rel="ugc">https://www.experts-exchange.com/questions/27546923/Spreadsheet-for-billable-time-tracking.html</a>
</div>


If you have the time, I have the points:

https://www.experts-exchange.com/questions/27546923/Spreadsheet-for-billable-time-tracking.html [https://www.experts-exchange.com/questions/27546923/Spreadsheet-for-billable-time-tracking.html]

<div>
<div class="content wysiwyg-content">
Hi Experts. &nbsp;With the help of a mastermind excel expert, I was able to get my spreadsheet to add the columns up on the spreadsheet based on the presence of a &quot;B&quot;. &nbsp;What I would like to do know is add the columns up if there is NO &quot;B&quot; present. &nbsp;Your assistance and time is great appreciated.<br />
<br />
Expert used SUMIF($A$10:$A$34,&quot;B&quot;,E10:<wbr />E34)<br />
<br />
What do I use if I want to add the columns without B?
</div>
</div>


Hi Experts.  With the help of a mastermind excel expert, I was able to get my spreadsheet to add the columns up on the spreadsheet based on the presence of a "B".  What I would like to do know is add the columns up if there is NO "B" present.  Your assistance and time is great appreciated.

Expert used SUMIF($A$10:$A$34,"B",E10:E34)

What do I use if I want to add the columns without B?

Add column if there is no letter code present

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.

Microsoft Office

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.