Create a summary sheet

Gopikrishna Mamidipudi

I want to create a sheet that computes all types of summary info from various other sheets. I have sheets called ProjectA, ProjectB, ProjectC. I also have a sheet called Summary-Info.

In Summary-Info I want to create rows of metrics, such as

Count of number of rows in ProjectA with Status="Done"

Count of number of rows in ProjectB with Status="Done"

Count of number of rows in ProjectC with Status="Done"

Count of number of rows in ProjectA with Status="In Progress"

Count of number of rows in ProjectB with Status="In Progress"

Count of number of rows in ProjectC with Status="In Progress"

Count of number of rows in ProjectA with Status="Done" in Year=2018

Count of number of rows in ProjectA with Status="Done" in Year=2019

Count of number of rows in ProjectA with Status="Done" in Year=2020

And so on.

I have a gazillion such counts, averages, sums based on multiple conditions? I have the Countif formula working in the Summary Tab of the sheet - but since I have over 400 such combinations using the Summary Tab is unwieldy.

How can I achieve this using any other method? Can I refer to cells in another sheet while creating a formula?

Gopikrishna Mamidipudi

I found my answer. Thank you.

Cross-sheet formulas | Smartsheet Learning Center