SUMIF Help
I'm trying to create a reference from another sheet to report on estimated sales by sales rep.
Here is what I tried:
=SUMIF([Sales Rep]:[Sales Rep], "JT Phillips", [Estimate Total]:[Estimate Total])
I get the unparsaeble error.
I need to pull this info into another sheet and then pull it into a dashboard. Can someone help me? Is there an easier way?
TIA!!
Answers
-
Here is an article with instructions on how to reference another sheet:
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks for the fast response!
I wouldn't use the SUMIF in this at all then? Would I use the above formula at all in this situation?
-
You would still use SUMIF. You just need to create the cross sheet references to point at the relevant columns for the criteria/total.
Rather than using the name in the formula and having to do each SUMIF individually, you could have your sales reps listed in a column on the sheet and then use this in the formula with an [Column]@row reference.
-
OK this is what I came up with but it's not working.
=SUMIFS({Sheet-Sales Pipeline Range 1}; [Sales Rep]@row, {Sheet-Sales Pipeline Range 1})
What am I missing?
Thank you all for your help!
-
You should have two different ranges. One that has the criteria to filter on and one that has the data to sum. Your syntax is also off, and you should be using just commas or just semicolons (depending on your region) between each section of the function.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
HAHA. I think this is over my head. Thank you for your help. I'll keep looking for an answer .
-
is this one closer? =SUMIFS({Sheet-Sales Pipeline Range 8}Estimate Total, {Sheet-Sales Pipeline Range 7}Sales Rep@row)
I am really finding this harder than it should be I feel.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!