Sheet Summary

I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?

Find more posts tagged with

Manufacturing

Sheets

Reports

Project Management

Update Requests

Comments

Mike Wilday

Currently, your best bet would be to add a summary section with data at the top of your sheet. There is no current way to write formulas on data from other sheets.

Mike Wilday

If you add a column to your sheet, you would be able to add something unique to your summary rows and then feed them into a report that is pulling from that sheet and only shows items with the value unique to your summary row. That would keep your summary data in a separate report, but it would exist on your sheet at the top.