Hi all, quick question (can't google it, OR & array give too much hits on Array formulas).
I have this formula
As the range is the same for each logical, I would like to shorten this.
I tried:
but to no avail.
Any ideas? Thanks!
I have this formula
Code:
=SUMPRODUCT((OR('Week 1'!$B5:$AN5="Brett",'Week 1'!$B5:$AN5="Michael",'Week 1'!$B5:$AN5="Stefan",'Week 1'!$B5:$AN5="Casual")*('Week 1'!B7:AN7)))
As the range is the same for each logical, I would like to shorten this.
I tried:
Code:
=SUMPRODUCT((OR('Week 1'!$B6:$AN6={"Brett","Michael","Stefan","Casual"})*('Week 1'!B8:AN8)))
Any ideas? Thanks!