This is a tricky one for me: I have this picture which represents my dataset. I am looking for 'if report name matches criteria, then return the sum of row 35, if X's were found in the column'. So for the row criteria and columns highlighted, I would require the formula to account for multiple X's found and then return the sum of row 35 (36+127=163).
<a href="https://ibb.co/fFGPmn"><img src="https://preview.ibb.co/eigqRn/2018_04_12_13_18_48.jpg" alt="2018_04_12_13_18_48" border="0"></a>
<a href="https://ibb.co/fFGPmn"><img src="https://preview.ibb.co/eigqRn/2018_04_12_13_18_48.jpg" alt="2018_04_12_13_18_48" border="0"></a>
Last edited: