App Icon
Custom functions that output a 2D array from a common range across multiple sheets.
Listing updated:November 7, 2021
Works with:
7,508
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.
​
Additional information
PricingFree
Developer
Trader status unspecified
Privacy policy
Terms of service
3D Reference will ask for the permissions shown below. Learn more
3D Reference will need access to your Google account
This will allow 3D Reference to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
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,
Is this review helpful?
Yes
No
Profile Picture
S Y
January 30, 2022
A very useful tool, but sometimes I see the message: Error Unknown function: 'DDDREF'. Deleting the formula and ctrl + z didn't help. Sometimes I have to come back to it later to find the extension working.
Is this review helpful?
Yes
No
Profile Picture
Michael Arndt
February 20, 2022
Seems helpful but I get an "exceed max execution" time error when running it on a larger financial sheet. Seems like a great tool. I hope the dev continues work on this.
Is this review helpful?
Yes
No
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu