Forum Discussion
Need help with Excel formula
I have two sheets in my workbook. Sheet 1 Title: "At a Glance". This sheet contains: Column C "Last Name" Column AF "Do not Recommend". Sheet 2 Title: "Overall Remarks". This sheet contain...
=SUMPRODUCT(('Overall Remarks'!B:B=C2)*('Overall Remarks'!C:H="Interview 1: Do not Recommend"))This formula returns the intended result in my Excel 2013 sheet.
=SUMPRODUCT(('Overall Remarks'!B:B=C2)*('Overall Remarks'!C:H="Interview 1: Do not Recommend"))This formula returns the intended result in my Excel 2013 sheet.
You are a genius 🙂 OliverScheurich