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

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

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).

Thank you. It works perfectly!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 383 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 291 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!