In cell H7, use an appropriate formula to add the total sales made in Perth for all the years. But I've decided to make the Formula to be independent

[ultramagnus23]

Artist	Place	Year	Sale
Taylor Swift	Sydney	2013	$ 3,067.00
Big Shaq	Melbourne	2009	$ 3,119.00
Ed Sheeran	Sydney	2017	$ 3,216.00
Coldplay	Brisbane	2007	$ 3,286.00
Taylor Swift	Brisbane	2006	$ 3,338.00
Ed Sheeran	Perth	2005	$ 3,430.00
Big Shaq	Brisbane	2000	$ 3,511.00
Adele	Melbourne	2009	$ 3,543.00
Ed Sheeran	Perth	2011	$ 3,590.00
Dua Lipa	Sydney	2002	$ 3,677.00
Big Shaq	Adelaide	2017	$ 3,695.00
Taylor Swift	Sydney	2009	$ 3,788.00
Big Shaq	Brisbane	2013	$ 3,874.00
Big Shaq	Brisbane	2012	$ 3,876.00
Ed Sheeran	Perth	2012	$ 3,937.00
Coldplay	Perth	2010	$ 3,960.00
Ed Sheeran	Perth	2014	$ 4,011.00
Taylor Swift	Adelaide	2013	$ 4,110.00
Taylor Swift	Sydney	2005	$ 4,114.00
Taylor Swift	Melbourne	2005	$ 4,212.00
Dua Lipa	Melbourne	2011	$ 4,215.00
Big Shaq	Brisbane	2001	$ 4,228.00
Taylor Swift	Melbourne	2014	$ 4,389.00
Big Shaq	Brisbane	2004	$ 4,391.00
Adele	Sydney	2014	$ 4,468.00
Adele	Melbourne	2012	$ 4,533.00
Adele	Melbourne	2000	$ 4,563.00
Ed Sheeran	Sydney	2001	$ 4,590.00
Ed Sheeran	Perth	2013	$ 4,705.00
Adele	Brisbane	2004	$ 4,722.00
Coldplay	Sydney	2006	$ 4,781.00
Dua Lipa	Adelaide	2006	$ 4,822.00
Taylor Swift	Sydney	2003	$ 4,932.00
Ed Sheeran	Perth	2001	$ 5,032.00
Big Shaq	Perth	2011	$ 5,090.00
Dua Lipa	Adelaide	2014	$ 5,250.00
Taylor Swift	Melbourne	2001	$ 5,257.00
Adele	Melbourne	2004	$ 5,293.00
Dua Lipa	Sydney	2017	$ 5,384.00
Big Shaq	Melbourne	2012	$ 5,403.00
Taylor Swift	Sydney	2002	$ 5,417.00
Dua Lipa	Adelaide	2001	$ 5,501.00
Adele	Melbourne	2005	$ 5,560.00
Adele	Adelaide	2010	$ 5,561.00
Dua Lipa	Melbourne	2016	$ 5,677.00
Coldplay	Melbourne	2015	$ 5,716.00
Ed Sheeran	Perth	2007	$ 5,748.00
Dua Lipa	Perth	2012	$ 5,827.00
Dua Lipa	Adelaide	2015	$ 5,840.00
Big Shaq	Brisbane	2007	$ 5,868.00
Ed Sheeran	Sydney	2007	$ 6,045.00
Adele	Melbourne	2011	$ 6,076.00
Coldplay	Brisbane	2012	$ 6,159.00
Dua Lipa	Adelaide	2013	$ 6,284.00
Taylor Swift	Sydney	2001	$ 6,356.00
Ed Sheeran	Brisbane	2009	$ 6,496.00
Adele	Melbourne	2016	$ 6,530.00
Dua Lipa	Adelaide	2000	$ 6,579.00
Adele	Perth	2003	$ 6,725.00
Coldplay	Brisbane	2008	$ 6,779.00
Adele	Perth	2010	$ 6,858.00
Taylor Swift	Adelaide	2014	$ 6,858.00
Big Shaq	Perth	2010	$ 6,861.00
Ed Sheeran	Perth	2003	$ 6,875.00
Big Shaq	Sydney	2017	$ 6,890.00
Taylor Swift	Sydney	2011	$ 6,950.00
Coldplay	Adelaide	2007	$ 7,029.00
Dua Lipa	Adelaide	2007	$ 7,044.00
Big Shaq	Adelaide	2004	$ 7,286.00
Coldplay	Melbourne	2011	$ 7,584.00
Ed Sheeran	Adelaide	2002	$ 7,719.00
Adele	Perth	2000	$ 7,740.00
Taylor Swift	Perth	2004	$ 7,882.00
Ed Sheeran	Adelaide	2012	$ 7,922.00
Big Shaq	Adelaide	2007	$ 7,937.00

<colgroup><col span="3"><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Answers

<tbody>
</tbody>

 

[Fluff]

Hi & welcome to MrExcel.
Have a look at Sumif https://exceljet.net/excel-functions/excel-sumif-function

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...he-total-sales-made-in-perth.html#post5092084

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.