Need help with an Excel Formula

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
For P2 use
=COUNTIF(opps!B:B,B2)
Matt PinkstonEnterprise Architect

Author

Commented:
awesome

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