# Help using sum if along with collect function

Can you please review my formula and tell me what I am doing wrong?

=SUMIF({*Capital Sales Pipeline Range 6}, "Yes", {COLLECT({Sheet - Sales Pipeline Range 2}, {*Capital Sales Pipeline Range 5}, "Won"))

• ✭✭✭✭✭✭

@Smartsheetuser12 You'd just make it a sum(collect()) The sumif and the collect portion are redundant.

Something similar to:

=sum(collect({Sheet - Sales Pipeline Range 2},{*Capital Sales Pipeline Range 6}, "Yes", {*Capital Sales Pipeline Range 5}, "Won"))

Certified Platinum Partner

2023 Partner of the Year

PrimeConsulting.com

• ✭✭✭✭✭✭

@Smartsheetuser12 You'd just make it a sum(collect()) The sumif and the collect portion are redundant.

Something similar to:

=sum(collect({Sheet - Sales Pipeline Range 2},{*Capital Sales Pipeline Range 6}, "Yes", {*Capital Sales Pipeline Range 5}, "Won"))

Certified Platinum Partner

2023 Partner of the Year

PrimeConsulting.com

• Thanks Matt!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!