SUMIF question

Kelli Peterson

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.

Samuel Mueller

@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)})

Kelli Peterson

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!

Samuel Mueller

@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?

Kelli Peterson

@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

Samuel Mueller

@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)})

Kelli Peterson

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

Again thank you @Samuel Mueller

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:

Kelli Peterson

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!

Samuel Mueller

Awesome! Glad it's working, let me know if you need anything else