I knew that a sumproduct formula was the answer. Thanks for helping faletti Sixthsense! The Apple excel version is a poor substitute for PC when it comes to excel.