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]

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

[TABLE="width: 613"]
<tbody>[TR]
[TD]Answers[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.