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
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!