SUMIF with criteria as a number

I'm trying to do a simple SUMIF formula but it isn't working and I think it is because I'm trying to use a number as the criteria. But I would think there is a workaround.

My main sheet has data like the below, where the same C/M is listed multiple times with different actual amounts.

On a separate sheet, I want to sum all the actual amounts for each C/M and tried the below but it results in a $0. But the result should be $17.00.

Any thoughts on what I am doing wrong?

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 06/19/21 Answer ✓

    Hi @Jennifer Lenander

    Hope you are fine, please try the following formula:

    =SUMIFS({Actual}, {C/M}, @cell = [C/M]@row)

    the following screenshot shows the result:

    Data Sheet

    Formula Sheet

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!