Two cells, one is $$

Hello! I am very new at trying to graph and formulas. I am trying to graph dollars associated with service type. They are in side by side cells. For example: Each OPD has a different dollar amount tied to it. I need a sum of all OPD dollars. I would appreciate any assistance.

Best Answer

  • James Keuning
    James Keuning ✭✭✭✭✭
    edited 11/20/23 Answer ✓

    In the Sheet Summary, put:

    =SUMIF(Metric:Metric, "OPD", Value:Value)

    If you want to create another sheet, where you can roll up the totals for all categories, you can use a cross-sheet reference.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!