JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
I am still trying to insert the INDIRECT argument to a SUMIFS formula.
The tab names on the Summary sheet are in Column B. They are month names from January to December. The other tab names are from January to December as well.
How do I insert INDIRECT please?
Here is my existing formula looking at the tab named January (for an example):
Thank you so much! Juicy
The tab names on the Summary sheet are in Column B. They are month names from January to December. The other tab names are from January to December as well.
How do I insert INDIRECT please?
Here is my existing formula looking at the tab named January (for an example):
Excel Formula:
=IFERROR(SUMIFS(January!$T$14:$T$2000,January!$R$14:$R$2000,$A7,January!$S$14:$S$2000,G$6),0)
Thank you so much! Juicy