Using cells in a reference for a metric sheet

Zcollins1995

Hello!

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?

Paul Newcome

Are you able to provide some screenshots for reference as well as the logic for which rows should be included?