<div>
Thanks, worked wonderfully.
</div>


<div>
<div class="content wysiwyg-content">
I currently have an excel document that uses the below formula to get a % of items in a row:<br />
<br />
=COUNTIF(M6:M36,$B$39)/$C$<wbr />37<br />
<br />
$B$39 contains LV which works well, as it calculates the % of items with LV.<br />
<br />
How do i change the formula so that it calculates two values T or LV. &nbsp;I have tried the below but it errors:<br />
<br />
=COUNTIF(AB6:AB36,$B$39)+(<wbr />AA6:AA36,$<wbr />B$38)/$C$3<wbr />7<br />
$B$39 contains value of LV &nbsp;$38 contains value of T<br />

</div>
</div>


I currently have an excel document that uses the below formula to get a % of items in a row:

=COUNTIF(M6:M36,$B$39)/$C$37

$B$39 contains LV which works well, as it calculates the % of items with LV.

How do i change the formula so that it calculates two values T or LV.  I have tried the below but it errors:

=COUNTIF(AB6:AB36,$B$39)+(AA6:AA36,$B$38)/$C$37
$B$39 contains value of LV  $38 contains value of T


% of of items in a Row with a T or LV

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