Want to use Sumif function with data from a different sheet

PWilliams

This is the formula I've come up with:

=SUMIF({Sales Funnel, Region:Region="EMEA",[Revenue]:[Revenue]})

Basically, I want to sum up all the values from the Sales funnel sheet for Region = EMEA; the Revenue has the actual values to add.

Any help would be greatly appreciated.

Paul Newcome

How exactly are you creating your cross sheet reference?

PWilliams

Hi Paul, I got some assistance through an internal space with my employer. Thank you for reaching out!

Mamie