Excel - 3D Sum with INDIRECT function | Excel Tips 78
In this tutorial about Excel, you will see how to make 3D Suma with INDIRECT function | Excel Tips 77
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
Used formulas:
=SUMPRODUCT(IFERROR(SUMIF(INDIRECT("'"&A2:A13&"'!"&C2)," większe niż 0"),0))
formula based on solution from:
https://excelchamps.com/formulas/indi...
--⏱️Timestamps⏱️--
00:00 | INDIRECT function - creating a text reference
02:12 | Create refrences to many sheets
03:40 | SUMPRODUCT function
04:38 | Sheets/names order
05:23 | Refrences to empty sheet names
06:21 | Single quotes in sheet names
07:31 | End
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelAndAdam #ExcelTips #excel