What formula to use for selective total sum by GEO
I have a spreadsheet (see below). I'd like to create a formula on a different sheet that can pull data from this sheet and show totals by GEO. So I'd like to have one for AMER, EMEAR and one for APJC. Would I use SUMIF?
I'm new to formulas and having a hard time understanding the process when creating the formula. Seems like all of the videos I've found rush through the process.
My ultimate goal is to have a dashboard that shows all totals by GEO in a pie chart.
Any help would be greatly appreciated, I'm very NOVICE.
Best Answer
-
You are missing a comma between the first and second ranges, the 3rd portion should either be a reference to a cell on the same sheet as the formula or "specific text", and you have one too many closing parenthesis on the end.
=SUMIFS({TEST TEST TEST Range 1}, {TEST TEST TEST Range 2}, "AMERICAS")
Answers
-
Yes. Using the appropriate steps to create a cross sheet reference and a metrics sheet that looks like this:
GEO.....................Formula
APJC.........................f
AMERICAS...............f
EMEAR.....................f
The formula would look similar to this:
=SUMIFS({Source Sheet DOLLARS Column}, {Source Sheet GEO Column}, GEO@row)
-
I hate sounding simple, but I want to make sure I'm doing this right. So when I create the formula I get UNPARSABLE.
Here's what I got: =SUMIFS({TEST TEST TEST Range 1}{TEST TEST TEST Range 2},{TEST TEST TEST Range 3}))
I typed the fomula, then "Reference Another Sheet" and chose the entire row for dollars, then put in a comma and chose "Reference Another Sheet" and chose the entire GEO row, then I put in a comma and chose "Reference Another Sheet" and chose a single cell with "AMERICAS". I then added a closed parenthetical.
I got UNPARSABLE
-
I hate sounding simple, but I want to make sure I'm doing this right. So when I create the formula I get UNPARSABLE.
Here's what I got: =SUMIFS({TEST TEST TEST Range 1}{TEST TEST TEST Range 2},{TEST TEST TEST Range 3}))
I typed the fomula, then "Reference Another Sheet" and chose the entire row for dollars, then put in a comma and chose "Reference Another Sheet" and chose the entire GEO row, then I put in a comma and chose "Reference Another Sheet" and chose a single cell with "AMERICAS". I then added a closed parenthetical.
I got UNPARSABLE
-
You are missing a comma between the first and second ranges, the 3rd portion should either be a reference to a cell on the same sheet as the formula or "specific text", and you have one too many closing parenthesis on the end.
=SUMIFS({TEST TEST TEST Range 1}, {TEST TEST TEST Range 2}, "AMERICAS")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!