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

wawaldo used Ask the Experts™
I currently have an excel document that uses the below formula to get a % of items in a row:


$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:

$B$39 contains value of LV  $38 contains value of T
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
you need extra  ( )
=(COUNTIF(M6:M36,$B$39) + COUNTIF(M6:M36,$B$39)) /$C$37


Thanks, worked wonderfully.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial