Help & Support
Send Feedback
3D Reference
Custom functions that output a 2D array from a common range across multiple sheets.
115 users
Works with
Install
Overview
This add-on adds two functions that both output a 2D array containing values from a common range across multiple sheets. The basic function takes sheets based on their name and the advanced function will iterate through numbered sheets at a configurable step, or use regex match to find matching sheets. These functions allow you to reference multiple sheets at once, without having to add them to your formula manually.
​
Reviews
A User of 3D Reference
February 6, 2018
Love the add-on. I could be able to sum all the cells across the 3d range with the below formula. =sum(DDDREF("first";"last";"A1")) However, when the values in reference cells change, the DDDREF formula do not update accordingly. I need to delete the formula and ctrl+z to recalculate. It would be great if recalculation is performed. BEst regards,
Submit reply
Cancel
A user of 3D Reference
December 19, 2018
Mmmh, can I use SUMIF?
A user of 3D Reference
February 19, 2018
Hell Doruk, an update for this issue has just been published. Check out the help page on my website or the 'Replace Functions' option in the add-on menu.
A user of 3D Reference
February 8, 2018
Hi Doruk, thanks for the feedback. This is something I'm looking into and I hope to publish the update soon. For a quick fix in the meantime add cell references inside the formula, like so: =SUM(DDDREF("first";"last";"A1",first!A1,last!A1))
1-1 of 1
Additional information
Search
Clear search
Close search
Google apps
Main menu