Count Info Across Multiple Sheets

Brian Wilson

Howdy!

 

I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. 

 

For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and show it in one place. 

 

Thanks!

John Sauber

That would be tasty, but I'm not sure it's on the menu.

SashaR

Are you wanting a sheet/report that displays a count of the number of projects for each region? You could build formulas on your 5 sheets that will count this, then use cell linking to link those cells (containing the formulas) to a master sheet where you can run your totals across all 5 sheets. Is that what you are looking for?

JamesR

Create a Row at the top of each sheet that counts the projects and have the task name as Region - Dashboard.

Create a report that filters on Task Name contains Dashboard

You should end up with five lines with the count numbers in each Refion

Data Solution Consultant

Hi Brian,

 

If you just want number of projects in your report then above answers would be able to help you get that.

 

If you need additional information and not just the number of projects - then

please provide more details and data samples for the report you need.

 

Thanks