1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Summing Total on Master List from Different Sheets in Same Workbook

Hey there,

I'm trying to get a running total from multiple spreadsheets that don't have an identical first column.

For Example, Jakob is on two position lists, but I would like his total to appear on the master list. Some employees are on multiple lists in different cells.

What is the best approach to get totals?

Master Total List

1st Position List

2nd Position List

submitted by /u/briann38002
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#natural language processing for spreadsheets
#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#AI-native spreadsheets
#Excel compatibility
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#cloud-native spreadsheets
#Excel alternatives
#google sheets
#master list
#running total
#Excel
#multiple spreadsheets
#totals
#position lists
#summing
#formula