Cross Sheet Sumifs Formula

Krystal Vaughn

Is there a way to run a formula from a cross sheet, that would pull specific names that are in the same cell. To formulate a group that worked together total revenue by the accounts that have "closed won"? I have more than one account holder at times per account

=SUMIFS({Sheet - Forecast Amount}, {MSS Sheet - MSS Account Owner}, FIND("Account Owner Name", "Other Account Holder Name", @cell) > 0, {Sheet - Sales Pipeline Range 4}, "Closed Won")

Paul Newcome

Try something like this...

=SUMIFS({Sheet - Forecast Amount}, {MSS Sheet - MSS Account Owner}, OR(FIND("Account Owner Name", @cell) > 0, FIND("Other Account Holder Name", @cell) > 0), {Sheet - Sales Pipeline Range 4}, "Closed Won")

Krystal Vaughn

Do I need CONTAINS instead of FIND....I keep getting "unparaseable"

Paul Newcome

Try something like this...

=SUMIFS({Sheet - Forecast Amount}, {MSS Sheet - MSS Account Owner}, OR(FIND("Account Owner Name", @cell) > 0, FIND("Other Account Holder Name", @cell) > 0), {Sheet - Sales Pipeline Range 4}, "Closed Won")

Krystal Vaughn

@Paul Newcome I received a number that time but it pulled the revenue of all the cells they were in, not just the cells that only had their names together, if that makes sense

Paul Newcome

Oh. My apologies. I didn't realize you were looking for both at the same time. Swap the OR out with an AND.

Krystal Vaughn

Ohh my gosh, I should have known that....you rock! Thanks so so very much, it worked!! @Paul Newcome

Paul Newcome

Happy to help. 👍️