SUMIF on 2 sheets

I have done this formula multiple times but cannot figure out why it is not working.

  • SD Form Sheet
    • SD Total Column (What I am trying to sum)
    • Site ID Column
  • SD Total Sheet
    • Site ID Column
    • Total SD (The column the formula is in)

What I and trying to do is Sum the SD Total Column if the Site ID Columns match. There can be more than one entry on the SD Form sheet with the same Site ID (value). I need the combined total for each of those.

Here is what each reference is pointing to:

{SD Form Range 33} = SD Total column on the SD Form Sheet.

{SD Form Range 2} = Site ID column on the SD Form Sheet.

Here is the formula I am using:

=SUMIF({SD Form Range 33}, [Site ID]@row, {SD Form Range 2})

It is returning a value of 0 and not the correct value.


Thank you in advance.

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Justin Mauzy

    The Range you want to sum needs to be the 3rd part of the SUMIF function:

    =SUMIF({SD Form Range 2}, [Site ID]@row, {SD Form Range 33})

    This could be confusing because the SUMIFS function works differently (the sum range comes first).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!