Pull data from 2 sheets into one



I am trying to make a table in one sheet, with counts of items coming from 2 other sheets when they meet certain criteria. I am using COUNTIF.

When entering the formula, I can only refer to sheet1. If I want to refer to sheet 2 in some of the rows, the whole column (all rows) will then be changed to the range in sheet 2.

any ideas?

thank you in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!