Using CountIf to get values from multiple sheets

Hi Smarties,

Just out of curiosity, is there a simpler formula when consolidating data from multiple sheets with the same column name?

For example, I have sheets Test 2 and Test 3. Both have status columns and I would like to count how many In Progress in my roll-up sheet.

It works when I do the following formula

=COUNTIF({Test2}, "In Progress") + COUNTIF({Test3}, "In Progress")

But surely there is an easier way to do this, no? Does anyone has any experience in this?

Thanks heaps guys!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!