Help & Support
Send Feedback
3D Reference
Custom functions that output a 2D array from a common range across multiple sheets.
125 users
Works with
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.
A User of 3D Reference
January 3, 2020
Jack-- Tried contacting you through your site but it wouldn't go through so trying here. First, I'm THRILLED that this add-on exists and it would be a huge help for my task-at-hand. Kudos! I was able to install it just fine but my IT department won't let me bypass our browser security preference to actually run the app because it hasn't been verified (despite the fact that it's on the g suite marketplace...). Specifically, the alert says " This app isn't verified This app hasn't been verified by Google yet. Only proceed if you know and trust the developer." I tried to bypass it but IT won't let me... Is there any way that you can request Google verifies your add-on? Thanks! (I'll edit this to a real review once I get the chance to use it.)
Submit reply
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
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-2 of 2
Additional information
Clear search
Close search
Google apps
Main menu