Excel: Aggregate the same cell across multiple sheets

preview_player
Показать описание
Please like and subscribe if you've found this video useful.
Рекомендации по теме
Комментарии
Автор

How if you simply need to copy a value from the same cell of different sheets into the main one to make a plot?

Bertld
Автор

I have a problem. When I create the formula and hold the shift key to select the tabs it wont select all the tabs.
EG: my formula is =SUM('A:Z'!Y6) it wont select A to Z but maybe only A to K. It is not seeing some of the tabs. Thank you in advance

carwash
Автор

That's the sum function not the aggregate function

cl
join shbcf.ru