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:
-
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.
-
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
- 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!