troubleshooting Question

Conditional subtotal formua

Avatar of Euro5
Euro5Flag for United States of America asked on
Microsoft Excel
5 Comments1 Solution398 ViewsLast Modified:
When filtered on A, count only "Top 80" visible.

Formula must be in cell E11, lists start at A13, B13, C13, D13, E13

Group      Cust      Name       $      FLAG
120      #      NM       $59,640           Top 80
120      #      NM       $32,100          Top 80
120      #      NM       $31,365          Top 80
120      #      NM       $30,138          Top 80
120      #      NM       $27,546          Top 80

Can anyone help?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 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 5 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