Hi, I made a formula that works: =SUMPRODUCT(Answer!U2:U65535,Answer!AD2:AD65535)/SUM(Answer!AD2:AD65535)
however, I need to update it for multiple conditions and I'm having some trouble with the specifics.
Referencing sheet "Answer", I want to perform the same calculation as above but for the sum of the following conditions:
Corresponding value in column A contains text "cr_3" or contains "dr_3" or contains "dv_3".
Those text values are partial matches (because, for instance, I don't want results from "cr_2" and should not be case sensitive.
I've been trying this between other projects for a few days now, but I'm just not getting anywhere. Any assistance would be greatly appreciated.
Also posted on Ozgrid, but no answer so far: http://www.ozgrid.com/forum/showthread.php?t=165637
however, I need to update it for multiple conditions and I'm having some trouble with the specifics.
Referencing sheet "Answer", I want to perform the same calculation as above but for the sum of the following conditions:
Corresponding value in column A contains text "cr_3" or contains "dr_3" or contains "dv_3".
Those text values are partial matches (because, for instance, I don't want results from "cr_2" and should not be case sensitive.
I've been trying this between other projects for a few days now, but I'm just not getting anywhere. Any assistance would be greatly appreciated.
Also posted on Ozgrid, but no answer so far: http://www.ozgrid.com/forum/showthread.php?t=165637