Originally Posted by
Hypnopoison
Hello
I was hoping that I could ask for some help please. I have uploaded an example spreadsheet to help demonstrate what I am attempting to do.
I need to work out a formula that takes the values from the 'Goal 1' (column B) - only for the country 'Australia' (column A) and copies those values in the corresponding 'Result' cell (column E). For every other country other than Australia, I need it to fill the cell with a 0.
I have populated that column manually with the result I am looking for.
Please can someone advise? what formula that I can use to achieve the same result?
Any help is very much appreciated.
Regards
Debbie
Bookmarks