I have looked over the threads that have the THREED function referenced, and I am really lost. I have 10 sheets that are all the same, and I want to use the THREED formula. This is what I have, and if anyone can help my ignorance I would appreciate it. Thanks in advance.
Sheet 1 is a summary sheet.
All Sheets that follow are labeled alphabetically, and cell contents in column A are identical. Column B the user was given the choice to make out of 5 references. I am wanting to sum on the Summary sheet particular choices. I tried to use the following formula in Sheet1!B4 to no avail
=sumproduct(--(threed(a:d!b7)="4=Very Well Aligned"),threed(a:d!b7))
Sheet 1 is a summary sheet.
All Sheets that follow are labeled alphabetically, and cell contents in column A are identical. Column B the user was given the choice to make out of 5 references. I am wanting to sum on the Summary sheet particular choices. I tried to use the following formula in Sheet1!B4 to no avail
=sumproduct(--(threed(a:d!b7)="4=Very Well Aligned"),threed(a:d!b7))