# 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.

Tags:

• Overachievers

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

• Overachievers

@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

• Overachievers

@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

• Overachievers

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