Avatar of Matt Pinkston
Matt Pinkston
 asked on

Need help with an Excel Formula

I have a xls with two sheets...   ACCTs and opps

In ACCTS column B is an account name
I need a formula for column P that will be the number of lines found in sheet opps where column B ACCTS is found in column B opps
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Matt Pinkston

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ejgil Hedegaard

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Matt Pinkston

ASKER
awesome
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck