Help using sum if along with collect function

Smartsheetuser12

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"))

Matt Lynn ACT

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

Matt Lynn ACT

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

Smartsheetuser12

Thanks Matt!