Custom functions that output a 2D array from a common range across multiple sheets.
Listing updated:November 29, 2023
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.
Additional information
PricingFree of charge
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
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Kaleb Axon
July 17, 2022
This function never recalculates its results after the initial calculation. You have to delete and re-enter it each time you change the cells that it references. Others have reported this issue yet still give it 4 or 5 stars, which I don't understand, since that basically makes it useless. I haven't personally done any add-on development, but there should be a way to tell Google Sheets that the results of this function must be recalculated every time. Unfortunately, even if that were corrected, the add-on would be too slow for any serious use. If you reference an entire column, such as saying DDDREF("Sheet1", "Sheet2", "A:A"), it doesn't optimize for blank rows, so it takes a few seconds to run each time. Imagine that happening every time you enter a value...
Is this review helpful?
Profile Picture
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?
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?
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?
1-4 of 4
Clear search
Close search
Google apps
Main menu