Excel formula with specific criteria

Hi, I have two spreadsheets that i want to link together. In spreadsheet 1 in cell D10 i want to get a total from spredsheet 2 but i am unsure how to do this as i have specific criteria it must meet. From C14 to C118 it must have an ‘X’ then I14 to I118 must be a ‘R’ i will then add up the totals from S14 to S118. How do i do this?

By: Lauren

Leave a Reply

Your email address will not be published. Required fields are marked *