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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!