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

wawaldo
wawaldo used Ask the Experts™
on
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
Comment
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
Commented:
you need extra  ( )
=(COUNTIF(M6:M36,$B$39) + COUNTIF(M6:M36,$B$39)) /$C$37

Author

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