troubleshooting Question

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

Avatar of wawaldo
wawaldo asked on
Microsoft Excel
2 Comments1 Solution290 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros