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!