Sum values from column based on criteria
Hello,
I am trying to sum values from a reference sheet based on common criteria. However I am running into either "#INCORRECT ARGUMENT SET" or values that are not the exact sum as expected.
My idea is to SUM the values from the attached request sheet (column 12), into the corresponding rows (column SUM) in the attached tracker sheet based on the matchup with criteria in column 4 in request sheet.
I have tried SUM function with VLOOKUP, obviously gives different values than I expected, and I am still struggling to understand why (Probably it's my lack of understanding the behaviour of the functions).
I would appreciate any kind of help or a point in the right direction.
Thanks!
Comments
-
Hi,
Can you describe your process in more detail and share the formulas that you're using? That would make it easier to help.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thanks for the reply!
Basically the process is as simple as already described with the screenshots, nothing besides that. At least for now.
I am trying to SUM the values from one sheet in a different sheet based on certain condition. (as marked on screenshot, based on Criteria1 for example)
So far as I was trying variations of SUMIF and SUMIFS formulas, but without any luck, and also SUM with VLOOKUP, but as already pointed out due to my own lack of understanding I am most probably missusing the formula.
Here is an example=SUM({request Range 1}, VLOOKUP([Primary Column]1, {request Range 2}, 8, false))
I would essentially appreciate any push in the right direction.
Thanks!
-
Try something along the lines of
=SUMIFS({Request Range 1}, {Request Range 2}, [Primary Column]@row)
{Request Range 1} should be Column12, and {Request Range 2} should be Column4.
-
Hi Paul,
Works!
Thank you so much for the suggestion.
Seems like I have to learn a bit more about the SUMIFS and criterions.
-
No worries. Practice makes perfect.
Happy to help.
-
Happy to help!
Paul beat me to answering.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I am having the same issue. I have tried SUMIFS, but I don't believe I am using it correctly.
I have a column labeled status and a column labeled sell. I have 4 or 5 options under status, but I only want to find the total for status's that are marked as "Sent". -
Hi,
Can you share the formula you're using now?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives