SUMIF question
Hello all! I am trying to update a SUMIF formula to sum a column's data for multiple names. It appears each time it will only include 1 name (POC) which is alphabetically first for the formula.
=SUMIF({Sort QPP  Q1 2023v2 (POC)}, [Column2]7, {Sort QPP  Q1 2023v2 (Feb Month)})
Thank you.
Best Answers

@Kelli Peterson thank you for the extra context!
Please try this and let me know if it works
=SUMIF({Sort QPP  Q1 2023v2 (POC)}, find([Column2]@row, @cell)>0, {Sort QPP  Q1 2023v2 (Feb Month)})

Thank you @Samuel Mueller for the additional context. Typing error on my part. Yes your suggestion worked great! Thank you again for your help and insight!
Answers

@Kelli Peterson the sum if formula will sum any values in {Sort QPP  Q1 2023v2 (Feb Month)} where values in {Sort QPP  Q1 2023v2 (POC)} match the value in [Column2]7. It does not matter what order they are in.
Do you have a screenshot of some sort or something or can you further explain what you are trying to do?

@Samuel Mueller Appreciate the reply. The 2 screenshots below represent the formula the information is being pulled in to and the bottom screenshot is where the information is being pulled for. Ultimately looking for more than 1 person to receive the FTE credit for each row they are listed whether the first one alphabetically or not. Hopefully that provides extra context. Thank you.
On this shot in the SUMIF formula only I would get the FTE credit SUMMED

@Kelli Peterson thank you for the extra context!
Please try this and let me know if it works
=SUMIF({Sort QPP  Q1 2023v2 (POC)}, find([Column2]@row, @cell)>0, {Sort QPP  Q1 2023v2 (Feb Month)})

Apologies but for clarification what is @cell referencing? When placing in the formula verbatim I receive #UNPARESABLE
Again thank you @Samuel Mueller

@Kelli Peterson you shouldn't have gotten unparseable.. hmm. You copied and pasted what I wrote?
=SUMIF({Sort QPP  Q1 2023v2 (POC)}, find([Column2]@row, @cell)>0, {Sort QPP  Q1 2023v2 (Feb Month)})
the POC is the range with contacts, and the Feb Month is the range of numbers to sum correct? and [Column2] is a name that you want to find and sum?
@cell evaluates each line in an array. Create Efficient Formulas with @cell and @row  Smartsheet Learning Center
this should explain that piece better:

Thank you @Samuel Mueller for the additional context. Typing error on my part. Yes your suggestion worked great! Thank you again for your help and insight!

Awesome! Glad it's working, let me know if you need anything else
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!