Combine and sum 6 sheets into one sheet or report

Kim G

I have 6 sheets all set up the exact same way:

1 category column + 12 columns for the months of the year

each sheet represents a different company

how can I combine (sum) the cells from each of the 6 sheets into one sheet or report?

ie: create a new report that sums the cells in row "expenses" , column " July" for all 6 sheets

I thought adding the 6 sheets into one report would do it, but it does not sum the cells, it displays the first sheet data only.

Andrée Starå

https://community.smartsheet.com/discussion/129712/combine-and-sum-6-sheets-into-one-sheet-or-report

Hi,

I hope you're well and safe!

It should work together with the Grouping/Summing feature.

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!