SUMIF from one or more reference sheets

michael.dilios15206
michael.dilios15206 ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" column.  Would I use VLOOKUP alongside SUMIF?   Attached give you an idea of the breakdown.  

 

Thanks,

Stats.JPG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    Michael, if I understand completely, I would use one formula with multiple COUNTIF functions (I prefer COUNTIFS because the syntax is the same for one or more criterion) to scan the other sheets and count the number of items associated with each category. You can use the new cross-sheet references to define the range to scan on each external sheet. If you have five external sheets there would need to be five COUNTIF functions each referencing a different sheet in the formula to count the number of Complete entries for each Category.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!