Count Index Match Cross Sheet Formula

edited 06/21/22 in Formulas and Functions

I'm pretty instantly stumped trying to make a count index match cross sheet formula.

I want a count of the Quantity column associated with those primary column part numbers. I have separate sheets for 213, 214, 215.

Here's a view of the 213 sheet:

Ideally it would be good to incorporate the status as well but I'm not sure how I'd do that. It would be nice to have counts of what's confirmed and what's already arrived. Maybe that would just mean separate cross sheet formula sheets for each status.

Does this make any sense? Any insight would be beyond appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!