Hi ,
my first posting, so I hope I explain this clearly, and would much appreciate if anyone can help, Thank you.
I am using sumproduct and currently use {"example a","example b",..etc} to determine which conditions are included, or use one constant location at a time, but I have quite a list this time. Is it possible to make reference to my list of conditions, which are stored in another tab in the file? so it will pick up any of the conditions that are found in my list? How would that be coded up?
Thank you.
my first posting, so I hope I explain this clearly, and would much appreciate if anyone can help, Thank you.
I am using sumproduct and currently use {"example a","example b",..etc} to determine which conditions are included, or use one constant location at a time, but I have quite a list this time. Is it possible to make reference to my list of conditions, which are stored in another tab in the file? so it will pick up any of the conditions that are found in my list? How would that be coded up?
Thank you.