How to count values within a dyanmic column in a range in another sheet?

Paul Lambert
Paul Lambert ✭✭✭
edited 03/08/23 in Formulas and Functions

Hi All,

I have a helper sheet (Sheet A) that I use to count cells in another sheet (Sheet B) based on various criteria. In one scenario, I'd like to count the number of cells in a column in Sheet B by matching various criteria. The challenge is that I'd like the formula to dynamically choose the column in Sheet B by matching a value in Sheet A to value in the first row of Sheet B. I can create separate range references for each column, but given the number of columns, I'd prefer to select the column dynamically. Thanks in advance.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!