Using cells in a reference for a metric sheet


I am quite new to smartsheet and had a questions about some widgets.

When referring to another sheet in my calculations sheet, I want to refer to a set of cells in a column instead of the entire column. However, I want it to update based on new info entered in the column. Also, anytime the sheet is sorted, it makes my CountIF formula inaccurate. How can I fix this?