Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Use letter to calculate data

Avatar of samiam41
samiam41Flag for United States of America asked on
Microsoft OfficeMicrosoft ExcelWindows 7
5 Comments1 Solution276 ViewsLast Modified:
Hi Experts.  Attached is the spreadsheet that needs an expert to add the missing part to it.   The spreadsheet has two sections (top and bottom).  The top section is where all of the information is manually entered that relates to customer information.  The first column is where I would like to enter a B if the line relates to information for a business.  The bottom of the spreadsheet is where I would like to have all of the business information summarized from the top (lines that have a B only).  I don't know how to calculate this based on a B being in the column.  Help.

Thanks for the help experts! FixMe.xlsx