Let me try to explain this a little better here. The Formula in cell C18 I would like for it to only read the data in column C only if there is an x in column A. I know you can just make the formula read the specific data from Column C but is there a way to make it look for an "x" in column A first. I am sorry for the horrible description the first time, hopefully this one is a little better
Question.xlsx
Bookmarks