Forum Discussion
Joannesweeney
Jan 28, 2022Copper Contributor
3d references-need help
How can I create a 3d reference using the same cell in sheets that are not in order/in a continuous range (i.e. 20 different sheets, want to add the same cell ONLY in sheets 1, 8, 15 and 22, etc....)
1 Reply
- SergeiBaklanDiamond Contributor
Perhaps this Excel formula: 3D SUMIF for multiple worksheets | Exceljet helps