Range for excel tables or columns to consolidate data as summary - Microsoft Community

how make range tables or columns across multiple sheets consolidate data in summary sheet using excel functions sum/sumif/sumifs/sumproduct/etc...?

example: table1[column1],table2[column1],table3[column1]...table50[column1]

table1[column1] in sheet name 's1'

table2[column1] in sheet name 's2'

table3[column1] in sheet name 's3'.

.

.

table50[column1] in sheet name 's50'

thanks...

hello pedy,

in creating dynamic defined ranged on worksheet consists of excel functions, best if familiar excel functions want use. assist you, suggest check article. there you'll see excel functions , how use it.

after familiarizing excel functions you'll using, can visit link. there, you'll see simple guide on how create dynamic defined range in excel worksheet.

let know if resolution provided works.

Office / Excel / Microsoft Office Programming / Office 2013